I have a spreadsheet where I need a cell to calculate the date (from a cell in column B) plus 14 days to get a due date, but leave the due date cell blank if there is nothing yet entered into column B. What formula should I use for this?

Dates can be added just like numbers. Add 1, you've added a day; add 14, you've added 2 weeks. An IF statement can perform a calculation IF the

logical_testargument is TRUE:=IF(B1="","",B1+14)

If B1 is equal to nothing, return nothing, otherwise return B1+14.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History