| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
25 days previous to today?
Hi,
Can anyone help? Is it possible to write a formula whereby it will calculate 25 weekdays previous to today? I have tried to do the following, however it includes saturdays and sunday too and i cannot work out how to avoid including weekends? =today()-25 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have a date chane if it is +/- 2 days from the previous date | Excel Discussion (Misc queries) | |||
| How do I add a range by date over 90 days older than today | Excel Discussion (Misc queries) | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| date functions for previous 60/90/180 days | Excel Worksheet Functions | |||
| how to calculate a date .. say 34 days from today | Excel Discussion (Misc queries) | |||
Threaded Mode
