| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display yesterday's date but only for weekdays?
Hi,
I have the following function : =TODAY()-1 The problem is that if we're monday it gives me sunday's date whereas I only want weekdays so in this case friday. Any idea on how to mod the function to do that? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Would like to add 20 working/weekdays to a date | Excel Discussion (Misc queries) | |||
| Date, Weekdays | Excel Discussion (Misc queries) | |||
| Subtracting weekdays from a date: | Excel Worksheet Functions | |||
| count weekdays in a date range | Excel Worksheet Functions | |||
| Date exclude weekdays | New Users to Excel | |||
Threaded Mode
