Thread: Leap Year
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jet Jet is offline
external usenet poster
 
Posts: 4
Default Leap Year

A have a simple formula:

K40 * D59 * B310

B310= 28 (Days in February)

I have cells that = year (2008, 2009 etc) that are not used in this formula.

I want a formula that will use 29 days ( as opposed to 28 as stated above)
when
calculating within a leap year. (I have a list of all leap years)

Thanks