Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Hi, I have a column of due dates and times (format: 11/08/04 11:00). 8 weeks worth and all on weekdays. I would like to calculate starting dates/times in the next column, but I need to take into account the weekends. You can't start the assignment on a weekend or work on the assignment on a weekend. So, I would like to take the due date/ time and subtract 2 days and 6 hours, but if the assignment time falls on a weekend, I need to subtract full days until I get to a weekday. So that everybody has the same amount of available to work on the assignment. What would a formula look like that could do this calculation? Thanks in advance Coolcat -- Collcat ------------------------------------------------------------------------ Collcat's Profile: http://www.excelforum.com/member.php...o&userid=15598 View this thread: http://www.excelforum.com/showthread...hreadid=277036 |
#2
![]() |
|||
|
|||
![]()
Hi
as a starting point: http://www.cpearson.com/excel/DateTimeWS.htm -- Regards Frank Kabel Frankfurt, Germany "Collcat" schrieb im Newsbeitrag ... Hi, I have a column of due dates and times (format: 11/08/04 11:00). 8 weeks worth and all on weekdays. I would like to calculate starting dates/times in the next column, but I need to take into account the weekends. You can't start the assignment on a weekend or work on the assignment on a weekend. So, I would like to take the due date/ time and subtract 2 days and 6 hours, but if the assignment time falls on a weekend, I need to subtract full days until I get to a weekday. So that everybody has the same amount of available to work on the assignment. What would a formula look like that could do this calculation? Thanks in advance Coolcat -- Collcat --------------------------------------------------------------------- --- Collcat's Profile: http://www.excelforum.com/member.php...o&userid=15598 View this thread: http://www.excelforum.com/showthread...hreadid=277036 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
How do I format column containing date and time to only show the . | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |