Using Dates in IF Statements 1

[DanielH]

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?

 

[IRstuff]

should look like:

=if(a1<>&quot;&quot;,a1+180,&quot;&quot

TTFN

 

[IRstuff]

Of course, the cell needs to be date formatted.

TTFN