I'm looking to create a formula that will allow me to count up the number of referrals made within a week.
If the date in column A falls between the Monday and the Sunday, I want it to be added to a tally count.
Any ideas how I can do this?
I'm looking to create a formula that will allow me to count up the number of referrals made within a week.
If the date in column A falls between the Monday and the Sunday, I want it to be added to a tally count.
Any ideas how I can do this?
Use COUNTIFS
Hence,
=COUNTIFS(Range,>=Startdate,Range.<=Enddate)
or for earlier versions fo Excel
=SUMPRODUCT((Range>=Startdate)*(Range<=Enddate))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks