| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Skip Weekends in date
I am trying to skip weekends from a date in a spreadsheet,
In Cell A1 I have todays date In cell A2 A3 A4 A5 I need it to be the previous days date so based on todays date A2 would be 12-17, A3 tho would have to be 12-14, A4 would have to be 12-13 and so on tomorrow tho A2 would be 12-18 A3 would be 12-17 A4 should be 12-14 ... what is the easiest way to accomplish this thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In MS Excel 03, how do I determine an end date (with weekends)? | Excel Worksheet Functions | |||
| Date Calculation to exclude weekends | Excel Worksheet Functions | |||
| Subtracting dates to get hours... but I want to skip weekends | Excel Discussion (Misc queries) | |||
| how can I skip weekends in excel? | Excel Worksheet Functions | |||
| Formula to make Excel count business days/skip weekends? | Excel Worksheet Functions | |||
Threaded Mode
