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 Contributor Last seen 27 December 2022 - 20 Apr 2017 à 11:37
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 20 Apr 2017 à 11:37
Related:
- Auto Generate Dates
- Android auto apk - Download - Other
- Nvidia auto detect - Guide
- What is auto download mms - Guide
- Twitter turn off auto translate - Guide
- Grand theft auto iv download - Download - Action and adventure
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
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