View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Excluding leap days in a formula

On Thu, 11 Dec 2008 05:05:00 -0800, PMBO
wrote:

Is there an excel function which could subtract (-1) from a formula if the
dates included the leap day? I don't want to count that one additional day
in a leap year; I know I can include a -1 in my formula, but I'm looking for
something that will decide if it's a leap year and automatically subtract it
from my date difference formula.


Your formula can be altered to not count Feb 29. Post your formula and someone
will show you how to account for that.
--ron