jubilee101
New Member
- Joined
- Apr 17, 2013
- Messages
- 25
I have a worksheet with a column which holds project due dates.
Format differs as below, depending on accuracy of finish date of project at current moment.
Apr-18 (Custom Date)
Aug-18 (Custom Date)
2018 - (general format)
Q4 2018 - (general format)
I am using a countifs formula to apply several criteria, with column AF holding the data above. I want to count anything that is in 2018 or -18 or 18
The formula below only counts line items with 2018.
=COUNTIFS('Projects'!A:A,"Yes",'Projects'!B:B,"Yes",'Projects'!C:C,"No",'Projects'!AF:AF,"*18*")
Is this possible?
Format differs as below, depending on accuracy of finish date of project at current moment.
Apr-18 (Custom Date)
Aug-18 (Custom Date)
2018 - (general format)
Q4 2018 - (general format)
I am using a countifs formula to apply several criteria, with column AF holding the data above. I want to count anything that is in 2018 or -18 or 18
The formula below only counts line items with 2018.
=COUNTIFS('Projects'!A:A,"Yes",'Projects'!B:B,"Yes",'Projects'!C:C,"No",'Projects'!AF:AF,"*18*")
Is this possible?