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 |