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.
|