Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2011
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Can someone please help with dates in IF statements?

    Hey,

    I am trying to write an IF statement to tell me different actions dependent on different dates and values in cells.
    The part I am having trouble with is this:

    What i want to do is say if the date in cell I2 is 7 days or more before today (ie it was over a week ago) it should say Send Reminder.

    I have tried this IF(I2=TODAY-7,"Send Reminder,"0")
    I know this is probably completly wrong! If someone could please help me that would be much appreciated!!

    Thanks

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Will this do what is desired ....

    =IF(I2<=TODAY()-7,"Send Reminder",0)

  3. The Following User Says Thank You to tfspry For This Useful Post:

    Ark93 (2011-05-26)

  4. #3
    New Lounger
    Join Date
    May 2011
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Works perfectly!! Thanks so much I thought it would be something silly i was missing

  5. #4
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Welcome to the Lounge.
    Glad I could help!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •