Count if project is starting within the next 30 days

andhou

Hi,

I'm trying to count how many projects will be starting within the next 30 days. I understand I can filter, but i need to run a report and I'm having difficulty with my formula. I'm fairly new with formulas. I continue to receive a "unparseable" error" . Any help would be greatly appreciated. Thank you in advance.

=COUNTIF({Reference master sheet target start date column}, AND ({Reference master sheet target start date column} <=TODAY(), {Reference master sheet target start date column}<=TODAY (30))))

James Keuning

I would create a checkbox helper column and something like Start Date<=TODAY (30) and count the TRUE responses.

andhou

Thank you James!

L_123

=countif(StartDate:StartDate,and(@cell > today(),@cell <= today(30)

andhou

Thank you James!