Date and if condition

Hi the community,

I’m looking a way to change date in a colunn.
I need to replace every date before 01-01-2022 by 01-01-2022 and keep those after 01-01-2022 by the date in the colunn
see an example
date before 1er JAN to replace by 01-01-2022.xlsx (8.1 KB)

i found it by myself.
convert data type “text to date” → new colun with if function.

1 Like

Thank you for posting a solution!