| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set a date as a constant to work back from to show only weekdays
I would like to input one date as a constant and then apply a formaula in
other cells relating to this date to calculate back from but to "round" back to only weekdays. For example if i type in a date of February 1st 2006 (a Wednesday) and would like to calculate backwards automatically by eleven days it is Sat Jan 21st 2006. I would like this to round back to the nearest previous workday which would be the Friday. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| the date format is not working ,sort by date doesn't work. | Excel Discussion (Misc queries) | |||
| Converting Date to Work Week... | Excel Discussion (Misc queries) | |||
| How do I format column containing date and time to only show the . | Excel Discussion (Misc queries) | |||
| Roll back to previous date | Excel Worksheet Functions | |||
| Show a date based on today | Excel Worksheet Functions | |||
Threaded Mode
