Solved excel formula for dates

June 13, 2012 at 10:48:23
Specs: Windows 7
i want to sum numbers between date ranges how do i do this?

See More: excel formula for dates

Report •


#1
June 13, 2012 at 11:10:34
Try using =DATEDIF()

=DATEDIF(1stDate,2ndDate,"Interval")

1st Date : Earliest date.
2nd Date : Most recent date.

"Interval" : What you want calculated.
Must be surrounded with quote marks.

Intervals can be:
"d" Days between dates.
"m" Months between dates.
"y" Years between dates.
"yd" Days between the dates, as if the dates were in the same year.
"ym" Months between the dates, as if the dates were in the same year.
"md" Days between the two dates, as if the dates were in the same month and year.

MIKE

http://www.skeptic.com/


Report •

#2
June 13, 2012 at 14:11:53
Not working .....
On my spreadsheet i have a column that is #'s and Column that is Dates, I want to take from say June 1-15 and add the Numbers...... help!!!!!

Report •

#3
June 13, 2012 at 14:23:48
✔ Best Answer
Try using the =SUMIF() function, here is a good example:

http://www.officearticles.com/excel...

You need a Start Date and End Date and the formula does the rest.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
June 14, 2012 at 10:26:44
THANK YOU SO MUCH!!!!!!
that worked awesome!!!!
Can you tell me if i have same kind of date range and need an average price do i use averageif?

Report •

#5
June 14, 2012 at 11:40:06
Can you tell me if i have same kind of date range and need an average price do i use averageif?

Why don't you try and see what happens?

MIKE

http://www.skeptic.com/


Report •


Ask Question