Calculate future date, but leave cell blank if no date is entered

**kyber** · 08-12-2021, 03:21 PM

I would like the "Next Review" date to calculate 7 days after what is entered in the "Last Updated" date. But, if the cell is blank, I would like the output to be left blank as well.

**JohnTopley** · 08-12-2021, 03:26 PM

Try

=IF(C1="","",C1+7)

**kyber** · 08-12-2021, 03:28 PM

Fantastic, thank you so much!

Calculate future date, but leave cell blank if no date is entered

LinkBack

Thread Tools

Rate This Thread

Display

Calculate future date, but leave cell blank if no date is entered

Re: Calculate future date, but leave cell blank if no date is entered

Re: Calculate future date, but leave cell blank if no date is entered

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Leave cells blank when there is not a date in the other cell that it is using to calculate

Calculate Date 5 years in the future past today's date

Date Formula and leaving cell blank when no date is entered

Calculate differnce between 2 dates, but if 1 date cell is blank leave cell blank

[SOLVED] Calculate Due Date and copy value from entered cell to the due date one

How to leave Date formula cell blank until date entry??

[SOLVED] formula to calculate future date from date in cell plus days

Bookmarks

Bookmarks

Posting Permissions