Forum Discussion
casino123
Sep 15, 2020Copper Contributor
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...
NikolinoDE
Sep 15, 2020Platinum Contributor
here a example
Formula in German
Formula in English:
=MIN(DATE(YEAR(A2)+B2,MONTH(A2)+C2+(DAY(A2+1)=1)+{1,0},DAY(A2)*{0,1}*(DAY(A2+1)>1)))
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.