Converting dates into days

R

Rehan Akhtar

HI..

I have data with dates in it.. I want to convert the
dates into days and then add data of all sundays, mondays
and so on.. the problem i am facing is that if I convert
the dates into days using "Format Cells" and then
customising it to display day only, the sumif and countif
formulas do not pick up days from the range i conver to
days..

pls help

Rehan
 
A

Alex Delamain

Add an extra column then use this

=text(a1,"ddd")

(assuming the dates are in column a
 
B

Bob Phillips

Don't bother with an extra column, just use

=SUMPRODUCT(--(WEEKDAY(A1:A100)=1))

for Sunday, changing the 1 to 2 for Mon, etc.
 
Top