Thread: Determining a leap year
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Determining a leap year
=IF(DAY(DATE(YEAR(TODAY()),3,0))=29,366,365)

is a better formula I think
Reply With QuoteReply With Quote