1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

I need a formula to automatically populate column D 'Progress' for percentage.

If the progress bar (column d) can automatically increase based on the duration of days that has passed, between the 'Start' and 'End' column for days. I now have a bar which can be tuned manually by inserting a percentage, but I want it automatic.

If you could please tell me the formula and the steps required to complete this request.

Thank you

Gantt Chart

submitted by /u/Trontific
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#rows.com
#formula generator
#Excel compatibility
#cloud-based spreadsheet applications
#Excel alternatives
#Progress
#percentage
#automatic
#formula
#Gantt Chart
#duration
#days
#column D
#Start
#End
#increase