trying to formulate a calculation

Kent Chong

COUNTIF({Range}, AND(>-365, <0))

so i have a column for # days to due date and based on that, i want to count the number of tasks that are due for the past 12 months and above is the formula that i created but im getting invalid operations. please advice further. i did include the range.

Bassam Khalil

Hi @Kent Chong

Hope you are fine, please try the following formula:

=COUNTIF({Range}, AND(@cell < 365, @cell > 0)) 

Bassam Khalil

@Kent Chong

Please try the following

=COUNTIF({Range}, @cell < Today(120)) 

Bassam Khalil

Hi @Kent Chong

Hope you are fine, please try the following formula:

=COUNTIF({Range}, AND(@cell < 365, @cell > 0)) 

Kent Chong

@Bassam Khalil do you have any idea on how to formulate a countif the completion date(range) is within 4 months from today's date?

Bassam Khalil

@Kent Chong

Please try the following

=COUNTIF({Range}, @cell < Today(120))