Solved I need an If/then formula to add a date in excel 2010

March 14, 2013 at 09:21:48
Specs: Windows XP
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?

See More: I need an If/then formula to add a date in excel 2010

Report •

#1
March 14, 2013 at 11:38:48
✔ Best Answer
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_test argument 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.


Report •
Related Solutions


Ask Question