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
Counting dates within a range 1
How do I have excel highlight days before & after a date on a cale 2
Need to calculate the number of days between two dates on a 30 day 5
Adding days to the WORKDAY function 1
query for Dates between today and 30 days back 4
Average last 30 days for each day in the quarter 7
Calculate a 30-day moving average based on the last x number of entries and date 14

Top