Using Dates in IF Statements
Using Dates in IF Statements
(OP)
I need to set up an if statement to show when to write a letter to someone 180 days after someone else has died.
e.g. =if(a1=anydate,a1+180days,leave blank)
A1 will have a date in it or nothing
Then you can see the date that the letter has to be done
Can this work or is there a long winded way that it can be done?
e.g. =if(a1=anydate,a1+180days,leave blank)
A1 will have a date in it or nothing
Then you can see the date that the letter has to be done
Can this work or is there a long winded way that it can be done?





RE: Using Dates in IF Statements
=if(a1<>"",a1+180,"")
TTFN
RE: Using Dates in IF Statements
TTFN