Formula for Timeline duration

Hi,
I have a Timeline column. When I mouse hover over it, it shows the duration in days.

I want a Formula column that shows this duration in months.

How can I reference the Start and End date in the Timeline, within my Formula column, to do this?

Thanks,
Pete

2 Likes

Pete,

Any luck here? I need the day count to populate so that I can automate per diem rates.

Nope! I haven’t worked it out, and silence on here.

have the same problem

Looking for the same here.

Found the answer!
This is the formula -
WORKDAYS({Dates#End},{Dates#Start})

1 Like

Wow! Thanks adi. That is fantastic!

SOLVED by adi - see above post :point_up_2:

1 Like

@adibar thanks, but this shows only working days… not all the timeline duration.

any way to get total days including weekends?

I found the formula i needed:
DAYS({Cronograma#End},{Cronograma#Start})+1

plus one, is because the formula miss one day in the operation