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 January 16, 2023 - Apr 20, 2017 at 11:37 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Apr 20, 2017 at 11:37 AM
Related:
- Auto Generate Dates
- Grand theft auto 1 download - Download - Action and adventure
- Nvidia drivers auto detect - Guide
- Auto redial - Guide
- Grand theft auto v free download - Download - Action and adventure
- Facebook auto refresh - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
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