Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IF function using dates

    XL97 SR2.

    Is it possible to get IF functions to work properly with dates? Eg, with a date formatted as 02/02/97 in cell A1,

    =IF(A1>06/06/97,"Later","Earlier").

    I have tried putting the 06/06/97 as shown, in brackets, and in inverted commas but none of them work.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: IF function using dates

    You could use the following formula :

    =IF(A1>DATEVALUE("06/06/97"),"Later","Earlier")

    Or you could put 06/06/97 in a seperate cell (say B1) and =IF(A1>B1,"Later","Earlier")

    Andrew C

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF function using dates

    Thanks Andrew

Posting Permissions

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