Contains 29 February
Hi All
I need to create a formula which will calculate whether the period between two specified dates contains the 29th February and return "Y" or "N".
Date one is located in cell B164, date two in cell D164 - the first date will always be earlier than the second.
I need to avoid macros as our network securities will not allow them.
Any help would be much appreciated!
Regards,
Amy
|