 # Get instant live expert help on I need help with excel calculate days from today “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need to calculate tenure in years, months, and days from a specific date until today. What formula do I use?
Solved by A. J. in 12 mins
Trying to calculate the average monthly sales, average sales for past 3 days, and average sales for past 7 days into 3 columns. I was working with someone, but what they created was not correct. for 3 days =SUMIFS('PPC Spend Raw'!\$P:\$P,'PPC Spend Raw'!\$A:\$A,"<="&TODAY(),'PPC Spend Raw'!\$A:\$A,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-3))/3 For the past 7 days:=SUMIFS('PPC Spend Raw'!\$P:\$P,'PPC Spend Raw'!\$A:\$A,"<="&TODAY(),'PPC Spend Raw'!\$A:\$A,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-7))/7
Solved by B. U. in 19 mins
how can i calculate a past date and how long its been as of today in days?
Solved by C. H. in 12 mins
I need a formula to calculate 'number of days' in which invoices entered by date wise up to today.
Solved by D. D. in 29 mins
I need a formula that will return a value based on date: If before today: .5 If today: 1 If between tomorrow and 7 days from now: 2 If after 7 days from now: 3 If no date: 4
Solved by S. J. in 26 mins