•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trending forecast in a month
Hello,
I am wondering if there is a way to find the trend of spent vs forecasted.
what I've been asked was to get the trending spent against the forecast as in, the first 20 days we've spent $2000, so over 30 days it should be $3000 (found by dividing total spent against number of days so far in the month then multiplying by total amount of days in month)
is there a way to have the excel spreadsheet do this calculation for me every day? or am I just stuck doing this manually every day?
thanks in advance.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#generative AI for data analysis
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#trending
#forecast
#spent