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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set a date as a constant to work back from to show only weekdays
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
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 |