Excel 2010: make a list of specific months workdays
Hello,
I'm trying to make a list of specific month's work days list and don't really know how to do it exactly. Month has 22 work days. trying to make table something like like this:
Workdays List Month's work day (November) 1 1 2 2 3 5 4 6 5 7 6 8 7 9 ... ...
Could someone explain me how could I do it?
Last edited by M0seS; 11-16-2012 at 03:32 AM.
Hi
is this what you're after?
Urm ye. But is there formula that would auto count and list work days of specific month? Now you have to write workdays manualy and link them.
not sure about a formula - would a macro do?
Anything would do
ok try this macro
it will prompt you for a start and end date, then type the workday number in successive rows starting in the selected cell, with the day of the month in the cell to the right
if you want to fix the place where the numbers are typed, change to eg
Please Login or Register to view this content.
Please Login or Register to view this content.
In A2 cell
=IF(ROW()=2,DATE(2012,11,1),A1+1)
Drag it down.
In B2 cell
=IF(ROW()=2,DATE(2012,11,1),IF(WEEKDAY(B1)=6,B1+3,B1+1))
Drag it down.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you, NickyC. Macro helped me alot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks