If Then Statement with Dates and Vlookup

[cmschmitz24]

I have a date being vlookup'd into column H from a different spreadsheet and then I need to determine if that date is greater than or less than 04/01/21 in column J. If it's older than 04/01/21, I need to have column J return 04/01/21. If it's newer than 04/01/21 then I need to have column J return the date vlookup'd into column H. My formulas are not calculating correctly. Please help.

The formula I have in column J is: =IF(H2>DATEVALUE("04/01/2021"),H2,"04/01/2021")

However, it works for the first row, the next rows are not returning the correct date wanted. Here's an example of what I'm getting -

row 2, column J should return 06/01/2021
rows 3-5, column J should return 04/01/2021

 

[cmschmitz24]

Thank you! Changing the master data to dates worked.

 

[Fluff]

You're welcome & thanks for the feedback.