M
Marcus
Hi,
I have a long list of tasks each with a different start date and end date
spanning several months. I have used networkdays function to calclaute the
total number of work days for the task. I now want a formula to try and
calculate the number of networkdays in each month for each task.
The task start and end dates do not coincide with the start and end of the
months and the months are not calender months.
I assume I need calculate the networkdays based on a nested if statements to
check if the task start end dates are > or < the month start and end dates
and then calculate . Or is there a simpler way to do this?
I have a long list of tasks each with a different start date and end date
spanning several months. I have used networkdays function to calclaute the
total number of work days for the task. I now want a formula to try and
calculate the number of networkdays in each month for each task.
The task start and end dates do not coincide with the start and end of the
months and the months are not calender months.
I assume I need calculate the networkdays based on a nested if statements to
check if the task start end dates are > or < the month start and end dates
and then calculate . Or is there a simpler way to do this?