LinkBack URL
About LinkBacks
In row 2 I have months rolling June 2012 - Nov 3013
In row 3 below the month can I automate the cell to calculate the number of working days (Mon - Fri) in that calendar month?
In row 2 I have months rolling June 2012 - Nov 3013
In row 3 below the month can I automate the cell to calculate the number of working days (Mon - Fri) in that calendar month?
Try this
=NETWORKDAYS(A2,EOMONTH(A2,0))
Hi and welcome to the forum
With a date in A2,In A3, try this
=NETWORKDAYS(DATE(YEAR(A2),MONTH(A2),1),EOMONTH(A2,0),Holidays)
Holidays is a named range with All your holidays.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks Bob, hoping I will be able to help you guys out one dayOriginally Posted by Bob Phillips
Hey Fotis, thank you for this. Do I create a list called holidays then that contains all UK bank holidays in? What format should the Holiday list be in? i.e. dd/mm/yy??
Yes. A date format.
hello
I want to calculate something similiar...
I want in first row to have the current year [ =year(now()) ]
In second row the months
and in third row to calculate the working days. So as a result when the year is changing to autocalcuate the working days.
Can anyone help me with this formula?
Also I would like to ask what would be the folmula if I would want to remove an extra number of working days.
Hi. Are you Greek?
You have to start a new thread with your question, according to the forum rules.
And even better to new thread, upload a small sample workbook.
yes i am Greek, Ok I will ask in a new thread. Φωτη αν μπορεις απαντησε μου....ευχαριστω
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks