| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for counting only Friday between to dates
i need a formula to count only Friday between to dates.
say, A1=Starting Date A2=End Date A3 will be the no. of Friday between A1 & A2 Pls. help.... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for counting only Friday between to dates
=INT((A2-WEEKDAY(A2+1-6)-A1+8)/7)
-- If this post helps click Yes --------------- Jacob Skaria "EricBB" wrote: i need a formula to count only Friday between to dates. say, A1=Starting Date A2=End Date A3 will be the no. of Friday between A1 & A2 Pls. help.... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for counting only Friday between to dates
one way:
=SUM(IF(WEEKDAY(A1:A19,2)=3,1)) CTRL+SHIFT+ENTER it as it is an array-formula On 26 Maj, 08:07, EricBB wrote: i need a formula to count only Friday between to dates. say, A1=Starting Date A2=End Date A3 will be the no. of Friday between A1 & A2 Pls. help.... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for counting only Friday between to dates
oops, sorry
did not read the post carefully On 26 Maj, 08:35, Jarek Kujawa wrote: one way: =SUM(IF(WEEKDAY(A1:A19,2)=3,1)) CTRL+SHIFT+ENTER it as it is an array-formula On 26 Maj, 08:07, EricBB wrote: i need a formula to count only Friday between to dates. say, A1=Starting Date A2=End Date A3 will be the no. of Friday between A1 & A2 Pls. help....- Ukryj cytowany tekst - - Pokaż cytowany tekst - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for counting only Friday between to dates
Another:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=6)) EricBB wrote: i need a formula to count only Friday between to dates. say, A1=Starting Date A2=End Date A3 will be the no. of Friday between A1 & A2 Pls. help.... -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to return date of following Friday | Excel Worksheet Functions | |||
| Formula to assist with counting dates | Excel Discussion (Misc queries) | |||
| Formula to assist with counting dates | Excel Discussion (Misc queries) | |||
| Formula to assist with Counting Dates | Excel Discussion (Misc queries) | |||
| challenging formula(for me), counting days between dates for multipleyears | Excel Worksheet Functions | |||
Linear Mode
