View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten
 
Posts: n/a
Default Calculate A Date Excluding Weekends And Holidays

=WORKDAY(A1,10)

Format as date
--
Kind regards,

Niek Otten

"travelersway"
wrote in message
news:travelersway.22wy5a_1139406608.6858@excelforu m-nospam.com...

I have a date and a series of tasks that need to be completed by a
certain number of days from the intial date. The time to complete the
tasks can not include weekends or holidays.
Example: Initial date is 2/15/2006
I have 10 business days to complete a task

All Help will be appreciated. Thank you.


--
travelersway
------------------------------------------------------------------------
travelersway's Profile:
http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=510032