COUNT IF duration between two dates & return 0 if one column is blank

ralter

I'm trying to count a cell if it meets the following criteria:
Termed Date - Hired Date = > Hired Date
or
if Termed Date is blank, count if Hired Date = > today's date

kowal

hi @ralter,

you can use nested if function witht he isblank function.

=if(ISBLANK(tdate@row), 1, if(tdate@row>=hdate@row, 1, 0)) its not exact function but the direction you shall go…

Paul Newcome

Are you able to provide some screenshots for context?

ralter

Sure! Thanks for your help!
I should clarify what I'm trying to solve,
Count if Termed Date is blank, but Hired Date is at least 31 days ago from today or
Count if Termed Date from Hired Date is at least 31 days between each dates

ralter

OkI think I may have figured it out.
=IF(NOT(ISBLANK([Hired Date]@row)), IF(OR([Termed Date]@row = [Hired Date]@row + 31, AND(ISBLANK([Termed Date]@row), [Hired Date]@row + 31 <= TODAY())), 1, 0), 0)

Paul Newcome

Glad you were able to get it sorted.

My personal approach would have been:

=IF([Hired Date]@row <> "", IF(IF([Termed Date]@row <> "", [Termed Date]@row, TODAY()) - [Hired Date]@row >= 31, 1))