View Single Post
  #5   Report Post  
Jason
 
Posts: n/a
Default

1/30-31 one mouth, 2/1-28 2mouth, 3/1-31 3mouth, 4/1-30 4mouth ,5/1-31
5mouth, 6/1-30 6mouth,

"Bernard Liengme" wrote:

Please explain why six months added to 1/29/2005 is 6/1/2005

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jason" wrote in message
...
I have a spreadsheet where I need Excel to calculate (ADD) 6 mouths
automatable for anther date. The mouths need to be consecutive. IE in one
cell I will put 1/29/2005 and in anther cell I need Excel to put 6/1/2005