IF Statement Using Dates

[SAMCRO2014]

I am trying to create an IF statement that is comparing the date in cell G20 to April 1, 2024. If G20 is less than 2024-04-01 then enter 2024-04-01 in the cell, if false, have the cell = date in G20.

This is my IF statement but it will not copy the data from G20 when false =IF(G20<"2024-04-01","2024-04-01",G20)

The true part of the statement works, I can't figure out why the false statement does not. I tried adding the DATE function with no sucess.

This should be 2024-07-04 and not 2024-04-01

Thank you

 

[arun_eagertolearn]

Please try =IF(G20<date(2024,4,1), date(2024,4,1),G20)
ie, replace "2024-04-01" with date(2024,4,1)
(assuming it is Apr 1st that you mean)

 

[RoryA]

You could also use:

=MAX(G20,date(2024,4,1))

 

[SAMCRO2014]

Please try =IF(G20<date(2024,4,1), date(2024,4,1),G20)
ie, replace "2024-04-01" with date(2024,4,1)
(assuming it is Apr 1st that you mean)

That worked! Thank you. I knew it had to be something simple I was missing.

 

[arun_eagertolearn]

Thanks for letting know that it has been of help