Is 3 months from date

[Moggzzz]

Hi

I am trying find out if one date value is greater than another date value by 3 months - is this possible? E.g. cell A1: 01/01/2020 and cell A2: 01/05/2020

Ofcourse (in UK date format) A2 is greater than cell A1 by 3 months, but what formula could be used to highlight this and then used at scale?

Thanks

[AliGW]

How about:

=DATEDIF(A1,A2,"m")>3

[AliGW]

Thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.