View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy - PEAK ASSIST Sandy - PEAK ASSIST is offline
external usenet poster
 
Posts: 1
Default Looking for a formula to calculate date intervals

I am not very good at complex formulas and need to figure out a way to
calculate date intervals, say 6 months before a certain date and 2 weeks
before that date, etc.

Example: Start with Oct. 9, 2006 in one cell. Now I need to calculate 6
months before that date in another cell, then 3 months in another, then 2
weeks in another and so on. Does anyone have any suggestions? I'm on Excel
2003 and looked at the "date" formulas and just can't seem to figure out how
to get what I need.

Thanks for your help in advance!