![]() |
#1
|
|||
|
|||
![]()
Good Morning Guys,
I need your help to find the suitable formula for the attached excel sheet which highlighted in red and it’s related to how to count the Fridays and Saturdays for the specific month. Please open the attached excel sheet. Your prompt reply and help will be highly appreciated. Regards, |
#2
|
|||
|
|||
![]()
You might have a problem as you are displaying dates which are numeric as days. If the days are numeric in the calendar then each Friday has a different value from the other Fridays and therefore it will only count once.
If you can set up the table so the day is alpha and not numeric then you could use =COUNTIF(B9:AC9,"Fri") |
#3
|
|||
|
|||
![]()
Try using the weekday function followed by the countif function. See attached.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Brigitte | Word | 7 | 06-15-2021 05:10 PM |
help with find and replace | sjkiss | Word | 1 | 04-12-2010 08:08 AM |
Excel Formula Help | masoom84 | Excel | 1 | 03-07-2009 09:41 AM |
![]() |
Shahzad | Excel | 1 | 12-07-2008 04:13 AM |
Find and Replace Macro - A Better Way | Tribos | Word VBA | 0 | 10-08-2008 03:22 AM |