Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to set up a function that will check the following
I am using Excel XP Pro I have a date in cell F9. It places a date in F1 that will be 7 days earlier. (This works fine) Question: If the date in F1 is a Saturday or Sunday, I need it to put the date of Monday in that cell. Does any one know the formula for this. Thanks in advance. bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Clear list from weekends | Excel Worksheet Functions | |||
removing weekends | Excel Worksheet Functions | |||
WEEKENDS VS. WEEKDAYS | Excel Discussion (Misc queries) | |||
WEEKENDS VS. WEEKDAYS | Excel Discussion (Misc queries) | |||
How do I set up a calculation to exclude weekends? | Excel Worksheet Functions |