Thread: date formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default date formula

On Sat, 12 Feb 2005 09:17:24 -0500, "Jim May" wrote:

ron, wouldn't there be a problem only if one were to begin their series with
the following 4:
8/29,
8/30,
8/31
or 2/29 ?


The problem will occur with the following dates:

29-Feb
31-Mar
31-May
29-Aug *unless subsequent year is a leap year
30-Aug
31-Aug
31-Oct
31-Dec


--ron