View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default date after another date

Create a list of all January holiday dates and put them in a range named
holidays, an use

=WORKDAY(DATE(YEAR(A20+360),12,31),1,holidays)

--
__________________________________
HTH

Bob

"Gator Girl" wrote in message
...
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.