COUNTIFs dates on a cloumn are within the last 30 days

Q

qfx2dna

Joined
Apr 21, 2011
Messages
3
Reaction score
0
:confused: I would like to countifs "(e5:ne5,"s")" and "countifs only those from the past 30 days at any given time based on a row of dates that are at the top of the spread sheet i feel that somewhere in there i need to refur to $E$4:$NE$4 as the reference because those cells contain the dates 1/1/11 thru 12/31/11 i just dont know how or where

=COUNTIFS(E5:NE5,"="&EDATE(TODAY(),1)-30,E5:NE5,"s")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Attendance tracker last 30 days 1
Countif Function?? 3
Counting dates within a range 1
How do I have excel highlight days before & after a date on a cale 2
Time and the Max Function 15
CALCULATE DAYS PER MONTH BETWEEN 2 DATES 2
Countif on multiple dates 6
Count within a date range 3

Back
Top