| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting WEEKDAY function to Exclude Friday in Calculation
I have to dates:
Cell A1 e.g 10/3/2004 Cell A2 e.g 22/9/2004 i want to calculate number of days between the two dates excluding Friday. Note: i am using Office XP 2002 -- Faizan Ahmad |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting WEEKDAY function to Exclude Friday in Calculation
Hi
try: =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))<5)) -----Original Message----- I have to dates: Cell A1 e.g 10/3/2004 Cell A2 e.g 22/9/2004 i want to calculate number of days between the two dates excluding Friday. Note: i am using Office XP 2002 -- Faizan Ahmad . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting WEEKDAY function to Exclude Friday in Calculation
Thanks for your reply,
the result is different if you apply it the formula to: A1 = 1/9/2004 a2 = 30/9/2004 Faizan "Frank Kabel" wrote: Hi try: =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))<5)) -----Original Message----- I have to dates: Cell A1 e.g 10/3/2004 Cell A2 e.g 22/9/2004 i want to calculate number of days between the two dates excluding Friday. Note: i am using Office XP 2002 -- Faizan Ahmad . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting WEEKDAY function to Exclude Friday in Calculation
Hi
sorry, wrong weeknumber exclusion. Make this: =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))<6)) This returns 26 for your example set of dates -----Original Message----- Thanks for your reply, the result is different if you apply it the formula to: A1 = 1/9/2004 a2 = 30/9/2004 Faizan "Frank Kabel" wrote: Hi try: =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))<5)) -----Original Message----- I have to dates: Cell A1 e.g 10/3/2004 Cell A2 e.g 22/9/2004 i want to calculate number of days between the two dates excluding Friday. Note: i am using Office XP 2002 -- Faizan Ahmad . . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting WEEKDAY function to Exclude Friday in Calculation
Dear Frand Kabel,
Thank you very much for comments, it really solved my problems. thanks Faizan "Frank kabel" wrote: Hi sorry, wrong weeknumber exclusion. Make this: =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))<6)) This returns 26 for your example set of dates -----Original Message----- Thanks for your reply, the result is different if you apply it the formula to: A1 = 1/9/2004 a2 = 30/9/2004 Faizan "Frank Kabel" wrote: Hi try: =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))<5)) -----Original Message----- I have to dates: Cell A1 e.g 10/3/2004 Cell A2 e.g 22/9/2004 i want to calculate number of days between the two dates excluding Friday. Note: i am using Office XP 2002 -- Faizan Ahmad . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weekday + Time Calculation in Cell | Excel Worksheet Functions | |||
| WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
| How do I set up a calculation to exclude weekends? | Excel Worksheet Functions | |||
| calculation to exclude weekends | Excel Worksheet Functions | |||
| Exclude cells from calculation? | Excel Programming | |||
Hybrid Mode
