How to calculate the working days and calendar days for every month-year ?
My report looks like this
HTML Code:
When the date hits oct 1st,2019 the above template dates change from oct-2019 through sept-2020. Similarly 2020,2021,etc
How to calculate the working days and calendar days for every month-year ?
My report looks like this
HTML Code:
When the date hits oct 1st,2019 the above template dates change from oct-2019 through sept-2020. Similarly 2020,2021,etc
For working days: =NETWORKDAYS(A1,EOMONTH(A1,0))
For calendar days: =DAY(EOMONTH(A1,0))
Last edited by jeffreybrown; 11-05-2018 at 05:48 PM.
HTH
Regards, Jeff
Can you paste the actual working formula or your sample workbook. I can't get that formula to work.
This is my month year formula. It displays 10-18.
Formula:Please Login or Register to view this content.
=networkdays(date(year(today())-if(month(today())>9,0,1),10,1),eomonth(date(year(today())-if(month(today())>9,0,1),10,1),0))
=day(eomonth(date(year(today())-if(month(today())>9,0,1),10,1),0))
On second thought...
In A1 >> =DATE(YEAR(TODAY())-IF(MONTH(TODAY())>9,0,1),10,1)
In B1 copied across to the right >> =DATE(YEAR(A1),MONTH(A1)+1,1)
Now in A2 >> =NETWORKDAYS(A1,EOMONTH(A1,0)) >> copy to the right
Now in A3 >> =DAY(EOMONTH(A1,0)) >> copy to the right
Highlight A1:A12
Custom Format
- Right click cell (or Ctrl + 1)
- Format Cells
- Number
- Custom
- Type: "MM-YY"
Last edited by jeffreybrown; 11-05-2018 at 06:41 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks