Hi
What is the formula to determine the 2nd Workday of a month?
Thank you
Hudas
Hi
What is the formula to determine the 2nd Workday of a month?
Thank you
Hudas
you can use this formula
=WORKDAY(DATE(2012,M,1)2)
where M is the month in question
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
Hi
Or, with your date in A1, put this formula...
=WORKDAY(DATE(YEAR(A1);MONTH(A1);1)-1;2;Holidays)
This will also calculate holidays of the month....
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.
Hi
An error is popping out when I use the above formula =WORKDAY(DATE(2012,February,1)2).
Thank you
Hudas
use the number 2 instead of the word February
=WORKDAY(DATE(2012,2,1)2)
Hi DGagnon & Fotis1991 I am so sorry but both formula seems not to work...this is my first time handling a function relating to date so please give me your kind consideration.
@DGagnon still an error is popping out.
@Fotis1991 your formula is giving #Name error...
Thank you
sorry i was missing a comma, and i shoudl be looking one day further back, try this
=WORKDAY(DATE(2012,2,1)-1,2)
Thank you!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks