View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] webster_amy@hotmail.com is offline
external usenet poster
 
Posts: 1
Default 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