Countif with dates

jll14

New Member
Joined
Mar 20, 2019
Messages
1
So Column A is a month (January), column B is the date an order was received, and column C is the date the order was processed. I'm trying to count how many times in the month of January the order was processed after the day it was received. I keep getting referred to SUMPRDUCT but that's not working and I need the month column criteria. I've tried- =countifs(A:A, "January", C:C>B:B) which of course does not work. Any suggestions?
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

lrobbo314

Well-known Member
Joined
Jul 14, 2008
Messages
2,848
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Try this,

=countifs(A:A, "January", C:C,">" & B:B)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,446
Messages
5,528,802
Members
409,836
Latest member
karnasrinivas
Top