Ways to see total duration in months

rossbollinger

I'm looking for a way to see the total duration of a project in months.

I've found the NETDAYS formula, but the unit is days, not months.

Is there a way around this?

Genevieve P.

Hi @rossbollinger

What about taking the total days between the two then dividing by 30?

=([End Date]@row - [Start Date]@row) / 30

You can use the ROUND function to round the number.

=ROUND(([End Date]@row - [Start Date]@row) / 30)

In this instance I'm rounding UP, so instead of 6 months it says 7 as it's closer to 7, but you could Round Down as well.

Cheers,

Genevieve

Genevieve P.

Hi @rossbollinger

What about taking the total days between the two then dividing by 30?

=([End Date]@row - [Start Date]@row) / 30

You can use the ROUND function to round the number.

=ROUND(([End Date]@row - [Start Date]@row) / 30)

In this instance I'm rounding UP, so instead of 6 months it says 7 as it's closer to 7, but you could Round Down as well.

Cheers,

Genevieve

rossbollinger

Thank you!!

rossbollinger

Thanks!