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!
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
I'd also like help with this formula. Is there a way to calculate the days completed using a formula rather than updating manually?