View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gator Girl Gator Girl is offline
external usenet poster
 
Posts: 36
Default date after another date

I'm setting up a spreadsheet which alerts us when a certain assignment is due.
In cell a3 is the start date.

I want to look at the start date, add 360 calendar days to it, and then
calculate the first workday in January following the 360 days.

i.e. if start date is 6/30/08, i'd want the formula to return the date
1/4/2010.
if start date is 4/30/09, i'd want the formula to return the date
1/3/2011.

and so forth.

thanx.