Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want a formula that can check on a date such as 1/1/2010 and return all the
work days for January for example. I used: =WORKDAY(DATE(YEAR($A$1),MONTH($A$1)+1,1),-21) and then in the cell below it: =WORKDAY(DATE(YEAR($A$1),MONTH($A$1)+1,1),-20) and on down to get all the days listed. However I need some kind of check on the month I am pulling the date from so it does not go over into the previous or following month depending on how many days in a month. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate workdays in a month. | Excel Discussion (Misc queries) | |||
Date plus month, year, or years in workdays | Excel Discussion (Misc queries) | |||
Amount of Workdays in a Month | Excel Worksheet Functions | |||
Count workdays remaining in a month | Excel Discussion (Misc queries) | |||
Dislpay count of workdays in a month? | Excel Worksheet Functions |