Black friday

ColdGeorge

Active Member
Joined
Aug 21, 2012
Messages
407
Office Version
  1. 2016
Platform
  1. Windows
Hi all

Is there an, easy, way to know how many fridays in a month?

Thanks in advance for your assistance.

ColdGeorge
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
How about
Excel Formula:
=INT((DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,2)))+6)/7)
 
Upvote 0
some more options to consider
T202004a.xlsm
ABCD
21-Jan-20555
31-Feb-20444
4a
Cell Formulas
RangeFormula
B2:B3B2= SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&A3-1)))=6))
C2:C3C2=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&EOMONTH(A2,0))))=6))
D2:D3D2=NETWORKDAYS.INTL(A2,EOMONTH(A2,0),"1111011")
A3A3=EDATE(A2,1)
 
Upvote 0
And just another possible option

Book1
ABCD
101/01/20205
201/02/20204
301/03/20204
401/04/20204
501/05/20205
601/06/20204
701/07/20205
801/08/20204
901/09/20204
1001/10/20205
1101/11/20204
1201/12/20204
1301/01/20215
1401/02/20214
1501/03/20214
1601/04/20215
1701/05/20214
Sheet1
Cell Formulas
RangeFormula
D1:D17D1=4+(DAY(A1-DAY(A1)+35)<WEEKDAY(A1-DAY(A1)-5))


Edit: Btw I do get issues with some of the posted formulas if the dates aren't for the 1st of the month i.e. 27/2/2020 and 30/3/2020
 
Last edited:
Upvote 0
Hi

Thanks for your help, they all work. But, to tell the truth, Fluff's is a lot easier.

ColdGeorge
 
Upvote 0
Glad we could help & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top