Forum Discussion
Need an IF formula with a date
I'm looking for the following formula to help with dates and deadlines: If the cell is blank, write "ASAP". If it's not blank, add 5 years to the date in the cell. Cell 1 would be: 1/1/2005 It...
Use the EDATE formula as below:
=IF(ISBLANK(B2), "ASAP", EDATE(B2,60))
The argument in EDATE needs to be the start date (B2) and the number of months you want to offset.
Please mark this as a reply if it helps!
This worked, thank you!!
