Hi,
Based on computer date, what would be the formulae to know how many Mondays are there in current month please
Hi,
Based on computer date, what would be the formulae to know how many Mondays are there in current month please
Sorry I go it
=SUMPRODUCT(N(TEXT(ROW(INDIRECT(DATE(YEAR(TODAY()),MONTH(TODAY()),1)&":"&EOMONTH(DATE(YEAR(TODAY()),MONTH(TODAY()),1),0))),"ddd")="Mon"))
Try
Monday = 1
Tuesday = 2
Wednesday = 3
Thursday = 4
Friday = 5
Saturday = 6
Sunday = 7
HTML Code:
Last edited by wk9128; 06-25-2021 at 11:13 AM.
this should work
=NETWORKDAYS.INTL(DATE(YEAR(TODAY()),MONTH(TODAY()),1),EOMONTH(DATE(YEAR(TODAY()),MONTH(TODAY()),1),0),"0111111")
the 0111111
decides the day of week starting MON
https://exceljet.net/excel-functions....intl-function
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks