Hi,
I am trying to find the total workdays for my Project, summarised by week:
My project Start & End Date has 18 workdays.
Question - how do i plot the workdays in each week in COLUMNS I to M
I am trying to find the total workdays for my Project, summarised by week:
My project Start & End Date has 18 workdays.
Question - how do i plot the workdays in each week in COLUMNS I to M
WeeklyTest.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
D | E | F | G | H | I | J | K | L | M | |||
3 | January | |||||||||||
4 | Name | Project | Start | End | Workday | 03/01/2022 | 10/01/2022 | 17/01/2022 | 24/01/2022 | 31/01/2022 | ||
5 | Jon Beecher | Sales 2020 | 01/01/2022 | 26/01/2022 | 18 | |||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H5 | H5 | =NETWORKDAYS(F5,G5) |