Auto Generate Dates
Closed
gerry_itac
Posts
1
Registration date
Monday 17 April 2017
Status
Member
Last seen
17 April 2017
-
17 Apr 2017 à 05:41
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Moderator Last seen 27 December 2022 - 20 Apr 2017 à 11:37
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Moderator Last seen 27 December 2022 - 20 Apr 2017 à 11:37
Hi All,
I am currently working a excel formula to input a Revision_Date in column A then it will auto generate the number of days per month(only weekdays) on column B(January), column C(February) and so on depending on the current date. Example if today is April 17, 2017 and my input in Column A is Feb 13, 2017, it will compute number of days from Feb 13 to Feb 28 (which is 12 days) to be generated on Column C(Feb). Then on March which is complete since it covers the whole month until today on Column D(Mar). Then comes to April to compute the days from April 1 to April 16 on Column E(Apr). Can someone help me as I am really not familiar with excel. Hoping someone can share any formulas/techniques on how to do it. Thanks in advance.
I am currently working a excel formula to input a Revision_Date in column A then it will auto generate the number of days per month(only weekdays) on column B(January), column C(February) and so on depending on the current date. Example if today is April 17, 2017 and my input in Column A is Feb 13, 2017, it will compute number of days from Feb 13 to Feb 28 (which is 12 days) to be generated on Column C(Feb). Then on March which is complete since it covers the whole month until today on Column D(Mar). Then comes to April to compute the days from April 1 to April 16 on Column E(Apr). Can someone help me as I am really not familiar with excel. Hoping someone can share any formulas/techniques on how to do it. Thanks in advance.
Related:
- Auto Generate Dates
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Grand theft auto iv download apk for pc - Download - Action and adventure
- Facebook auto refresh - Guide
- Auto redial samsung - Guide
- Op auto clicker download - Download - Mouse and keyboard
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Moderator
Last seen
27 December 2022
555
20 Apr 2017 à 11:37
20 Apr 2017 à 11:37
Hi Gerry,
Give this a try.
Input data:
A2: 17-2-17
B1: 31-1-17 format as 'mmmm' to display january
C1: 28-2-17 format as 'mmmm' to display as februari
etc. for the other months
Input formula:
B2: =NETWORKDAYS("1-1-17",IF($A2>B$1,B$1,$A2-1))
Drag this formula down and to the right.
B2 should display 22 and C2 should display 12 in this example.
Best regards,
Trowa
Give this a try.
Input data:
A2: 17-2-17
B1: 31-1-17 format as 'mmmm' to display january
C1: 28-2-17 format as 'mmmm' to display as februari
etc. for the other months
Input formula:
B2: =NETWORKDAYS("1-1-17",IF($A2>B$1,B$1,$A2-1))
Drag this formula down and to the right.
B2 should display 22 and C2 should display 12 in this example.
Best regards,
Trowa