How can I calculate the amount of working days passed since the beginning of this month?
I know about WORKDAYS formula, but it seems like you must specify the amount of days yourself, so I don't know how to use it in my case.
Thanks!
How can I calculate the amount of working days passed since the beginning of this month?
I know about WORKDAYS formula, but it seems like you must specify the amount of days yourself, so I don't know how to use it in my case.
Thanks!
NETWORKDAYS is the function for counting workdays between two dates, so from the start of the month, including today try this formula
=NETWORKDAYS(EOMONTH(TODAY(),-1)+1,TODAY())
Audere est facere
Beautiful!
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks