Greater than/Less than between 2 Dates [Solved/Closed]

Report
Posts
4
Registration date
Monday May 13, 2013
Status
Member
Last seen
May 13, 2013
-
Posts
2744
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 10, 2021
-
i am trying to to populate a spreadsheet that if the date is less than 01/01/2013 then populate the cell with $500.00, if the cell is equal to or greater than 01/01/2013 then populate the cell with $38.46. What am I doing wrong? When I change the <> signs around one of the formulas works.

Here is the formula: =IF(B18<=1/1/2013,"$38.46","$500.00")

2 replies

Posts
2744
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 10, 2021
460
Hi Shaynajr,

That is because you didn't told Excel it is a date.

Try this:
=IF(B18>=DATE(2013,1,1),"$38.46","$500.00")

Best regards,
Trowa
Posts
4
Registration date
Monday May 13, 2013
Status
Member
Last seen
May 13, 2013

Thank you so much - it worked. You rock.
Posts
2744
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 10, 2021
460
Thanks for the feedback.

See you around.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!