Return Date Formula

luisitocarrion1900

Board Regular
Joined
Oct 30, 2017
Messages
120
Office Version
365
Platform
Windows
I need this fix that if it has a date in the return column it will count it

=COUNTIFS(List[Activity],Category1,List[Return Date])
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,118
Office Version
365
Platform
Windows
Dates are actually stored as numbers in Excel, so all you need to check for is a value greater than zero .
So use ">0" as the criteria argument for your date field.
 

Forum statistics

Threads
1,089,642
Messages
5,409,489
Members
403,266
Latest member
HMR120

This Week's Hot Topics

Top