| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scheduling
Probably for you this is very easy, I am trying to get how many saturdays and sundays are between 2 dates, this using a single worksheet in excel. In cell A1 provide the start date, in cell B1 provide finish date, and in cell C1 get how many saturdays and sundays there are. Would you mind help me in this trouble. Best Regards !!  -- jose.rodriguez ------------------------------------------------------------------------ jose.rodriguez's Profile: http://www.excelforum.com/member.php...o&userid=33339 View this thread: http://www.excelforum.com/showthread...hreadid=531692 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Scheduling
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=6))
where a1 and B1 hold the start and end dates -- HTH Bob Phillips (remove nothere from email address if mailing direct) "jose.rodriguez" <jose.rodriguez.262j1b_1144705804.6634@excelforu m-nospam.com wrote in message news:jose.rodriguez.262j1b_1144705804.6634@excelfo rum-nospam.com... Probably for you this is very easy, I am trying to get how many saturdays and sundays are between 2 dates, this using a single worksheet in excel. In cell A1 provide the start date, in cell B1 provide finish date, and in cell C1 get how many saturdays and sundays there are. Would you mind help me in this trouble. Best Regards !! -- jose.rodriguez ------------------------------------------------------------------------ jose.rodriguez's Profile: http://www.excelforum.com/member.php...o&userid=33339 View this thread: http://www.excelforum.com/showthread...hreadid=531692 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Scheduling
Sorry, that should be
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))={1,7})) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "jose.rodriguez" <jose.rodriguez.262j1b_1144705804.6634@excelforu m-nospam.com wrote in message news:jose.rodriguez.262j1b_1144705804.6634@excelfo rum-nospam.com... Probably for you this is very easy, I am trying to get how many saturdays and sundays are between 2 dates, this using a single worksheet in excel. In cell A1 provide the start date, in cell B1 provide finish date, and in cell C1 get how many saturdays and sundays there are. Would you mind help me in this trouble. Best Regards !! -- jose.rodriguez ------------------------------------------------------------------------ jose.rodriguez's Profile: http://www.excelforum.com/member.php...o&userid=33339 View this thread: http://www.excelforum.com/showthread...hreadid=531692 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scheduling | Excel Discussion (Misc queries) | |||
| scheduling | Excel Worksheet Functions | |||
| Scheduling... | Excel Discussion (Misc queries) | |||
| scheduling | Excel Worksheet Functions | |||
| Scheduling | Excel Discussion (Misc queries) | |||
Hybrid Mode
