| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Training | New Users to Excel | |||
| Mortgage calculator: finish date? | Excel Worksheet Functions | |||
| training sheets - date calculation | Excel Discussion (Misc queries) | |||
| VBA Training | Excel Discussion (Misc queries) | |||
| Training | Excel Discussion (Misc queries) | |||
Linear Mode
