LinkBack URL
About LinkBacks
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.
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.
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??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks