# Greater than/Less than between 2 Dates

Solved/Closed
Shaynajr Posts 4 Registration date Monday May 13, 2013 Status Member Last seen May 13, 2013 - May 13, 2013 at 11:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 13, 2013 at 11:36 AM
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")
Related:

## 2 replies

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 547
May 13, 2013 at 11:30 AM
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
Shaynajr Posts 4 Registration date Monday May 13, 2013 Status Member Last seen May 13, 2013
May 13, 2013 at 11:31 AM
Thank you so much - it worked. You rock.
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 547
May 13, 2013 at 11:36 AM
Thanks for the feedback.

See you around.