Thread: Edate problems
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jodi Jodi is offline
external usenet poster
 
Posts: 22
Default Edate problems

I am having problems wtih getting the correct date. My start date is 03/12/06
in cell C4 and I want to calculate 6 calendar months from that date into
another cell. All I end up with is 09/12/06, when it should be done in
regular calendar months. The answer should be 09/21/06 but I don't know how
to get the formula to get that date. I tried using just the date function and
then tried edate function. Please help