Converting dates into days

[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

 

[Alex Delamain]

Add an extra column then use this

=text(a1,"ddd")

(assuming the dates are in column a

 

[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.