Interactive Dashboard - Days completed formula|Dashboards & Charts|Excel Forum|My Online Training Hub

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!