Thread: Help with Date!
View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Help with Date!

It depends upon what the date you want to add to is. Personally, I would
never add 10 months by adding DATE(0,10,0) because that is 274 days, not 10
months.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dlw" wrote in message
...
So, in Excel, when you ask- How do I add 10 months to a date? The answer

is,
it depends on which 10 months you want to add...