hi everybody
find Number Of Mondays In Period
I need the number of Monday's that occur within an interval between two dates,
I use the following Array Formula:
=SUM(IF(WEEKDAY(A2-1+ROW(INDIRECT("1:"&TRUNC(B2-A2)+1)))=C2,1,0))
This formula assumes the following:
A2 contains the beginning date of the interval
B2 contains the ending date of the interval
C2 contains the day-of-week number (1=Sunday)
but same one is not working in my spreadsheet.
can anybody guide me.?
find Number Of Mondays In Period
I need the number of Monday's that occur within an interval between two dates,
I use the following Array Formula:
=SUM(IF(WEEKDAY(A2-1+ROW(INDIRECT("1:"&TRUNC(B2-A2)+1)))=C2,1,0))
This formula assumes the following:
A2 contains the beginning date of the interval
B2 contains the ending date of the interval
C2 contains the day-of-week number (1=Sunday)
but same one is not working in my spreadsheet.
can anybody guide me.?