ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   training day date calculator (https://www.excelbanter.com/new-users-excel/179315-training-day-date-calculator.html)

KiowaPilot

training day date calculator
 
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

OssieMac

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



All times are GMT +1. The time now is 09:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com