Formula for Timeline duration

Platform discussions
,
1

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

5 Likes
2

Pete,

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

3

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

4

have the same problem

5

Looking for the same here.

6

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

4 Likes
7

Wow! Thanks adi. That is fantastic!

SOLVED by adi - see above post :point_up_2:

1 Like
8

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

any way to get total days including weekends?

9

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

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

3 Likes