Forum

Notifications
Clear all

Interactive Dashboard - Days completed formula

3 Posts
3 Users
0 Reactions
125 Views
(@sunnyd)
Posts: 1
New Member
Topic starter
 

Hi Mynda, Thank you SO much for your tutorial video, I just found it and it is very helpful!

I'm taking on the task of creating my own dashboard for our projects and I'm having a bit of trouble with computing the Days Completed.

I'm trying to automatically calculate this column and if I use this formula in the Days Completed column, it changes the Progress percentage to well over 100% as time goes on. =TODAY()-[@[Start Date]]

So I thought I could try this formula (saw in the video comments) but I keep getting errors. =IF(AND(TODAY()>[@[Start Date]],TODAY()<=[@[End Date]]),(TODAY()-)-1,0)

Start date and Duration columns are hard coded. End Date formula is =WORKDAY.INTL([@[Start Date]]-1,[@Duration],1)

Do you see anything here that is off in the formulas?

Thank you so much for any assistance you can provide!

 
Posted : 09/07/2022 5:55 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Sunny,

Welcome to our forum. Please share your Excel file, or if it's too big, share a small mockup that illustrates the problem.

Mynda

 
Posted : 10/07/2022 7:21 pm
(@n-duffy)
Posts: 1
New Member
 

I'd also like help with this formula. Is there a way to calculate the days completed using a formula rather than updating manually?

 
Posted : 06/09/2022 8:12 am
Share: