Auto Generate Dates
Closed
gerry_itac
Posts
1
Registration date
Monday April 17, 2017
Status
Member
Last seen
April 17, 2017
-
Apr 17, 2017 at 05:41 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 20, 2017 at 11:37 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 20, 2017 at 11:37 AM
Related:
- Auto Generate Dates
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Facebook auto refresh - Guide
- Grand theft auto iv download apk for pc - Download - Action and adventure
- Auto redial samsung - Guide
- Nvidia drivers auto detect - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 20, 2017 at 11:37 AM
Apr 20, 2017 at 11:37 AM
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