Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to calculate next WORKDAY?
I need help with an IF statement/function for an Excel spreadsheet.
Here is what I am trying to do: If I have a date in a cell and it happens to be Saturday or Sunday, I want the IF statemnt to give the next WORKDAY. For example: 12//3/2005 Saturday The functin should look at this date, determne that is A WEEKEND date, then provide the next WORKDAY 12/05/2005 Monday. Any suggestions? The Tan Man |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Last workday | Excel Worksheet Functions | |||
Calculate next workday after adding calendar days to date in cell | Excel Worksheet Functions | |||
Add no. of days to a workday to get new workday? | Excel Worksheet Functions | |||
WORKDAY | Excel Worksheet Functions | |||
How do you calculate workdays if Saturday is a workday? | Excel Worksheet Functions |