View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default training day date calculator

If you look up Workday function it will probably do what you want.

--
Regards,

OssieMac


"KiowaPilot" wrote:

I am working on a spreadsheet that will automatically input dates. To
calculate the day a class graduates. I need for it to exclude weekends and
holidays. It would be best If I could make it use the =A1+1 formula somehow
as we often change dates due to cancellation of training.

TD Date
1 1 Mar
2 2 Mar
3 3 Mar