Sheet Summary Formula - (status type) due in next 7 days

AlixGustav

I have a manually altered date column [Next BHL Follow Up Date]

and a status column with a few options such as "Give Reminder to Attend Appointment"

How do I get a sheet summary that tells me the number of Give Reminder to Attend Appointment s are dated for the next 7 days?

Thanks,

Alix

DKazatsky2

Hi @AlixGustav,

Try this. =COUNTIFS(Date:Date, >=TODAY(), Date:Date, <=TODAY(7), Status:Status, "Give Reminder to Attend Appointment")

Make sure to change the column names as appropriate.

Hope this helps,

Dave

DKazatsky2

Hi @AlixGustav,

Try this. =COUNTIFS(Date:Date, >=TODAY(), Date:Date, <=TODAY(7), Status:Status, "Give Reminder to Attend Appointment")

Make sure to change the column names as appropriate.

Hope this helps,

Dave

AlixGustav

Perfect, that worked. Thanks!!