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. |
Set a date as a constant to work back from to show only weekdays
|
All times are GMT +1. The time now is 06:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com