Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Dates in IF Statements 1

Status
Not open for further replies.

DanielH

Computer
Joined
Aug 10, 2001
Messages
7
Location
GB
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?
 
should look like:

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

TTFN
 
Of course, the cell needs to be date formatted.

TTFN
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top