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!”
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