If the value of AK5 > than the value of AE5, automatically change the value of AE5

[Excelvirgin24]

Hello, could anyone help me by suggesting a formula for the following problem please?

AE5 and AK5 will both have dates written in them.

If the date in AK5 is later than the date in AE5, I want the date in AE5 to reset and match the date in AK5.

Would anybody know the formula for this?

Thank you very much in advance.

[Moo the Dog]

You would have to use a macro/VBA to do this. You can't have a formula and a value in AE5 at the same time.

- Moo

[Moo the Dog]

Something basic like this might work:

Please Login or Register  to view this content.

If you want to make this change down multiple columns the code can be changed to do so.

- Moo

[Moo the Dog]

Here's code that will propagate the routine down multiple rows for the rows you specify:

Please Login or Register  to view this content.

- Moo