Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Excel to use a 5 Day Week
I am trying to create a scheduling spreadsheet. I enter an end date in the date code and then work backwards to get the deadline dates for the different processes. My problem is that we only work 5 days a week and often the deadlines will be Saturday or Sunday. Is there some way to get Excel to figure only a 5 day week and completely ignore Saturday and Sunday? Thanks so much for your help. -- Melancholy ------------------------------------------------------------------------ Melancholy's Profile: http://www.excelforum.com/member.php...o&userid=30156 View this thread: http://www.excelforum.com/showthread...hreadid=498389 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Excel to use a 5 Day Week
See the WORKDAY and NETWORKDAYS functions.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Melancholy" wrote in message ... I am trying to create a scheduling spreadsheet. I enter an end date in the date code and then work backwards to get the deadline dates for the different processes. My problem is that we only work 5 days a week and often the deadlines will be Saturday or Sunday. Is there some way to get Excel to figure only a 5 day week and completely ignore Saturday and Sunday? Thanks so much for your help. -- Melancholy ------------------------------------------------------------------------ Melancholy's Profile: http://www.excelforum.com/member.php...o&userid=30156 View this thread: http://www.excelforum.com/showthread...hreadid=498389 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
update week to week in excel. | Excel Worksheet Functions | |||
update week to week in excel. | Excel Worksheet Functions | |||
How do I change from a 7 day week to a 5 day week in Excel? | Excel Discussion (Misc queries) | |||
How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) |