Count # of cells approaching a date for sheet summary

rbattista

I'm trying to create a sheet summary field that counts the number of cells in a column that are less than a week from the date in the cell.

This is what I've tried:

=COUNTIF(Off-Site to On-Site Return Estimation:Off-Site to On-Site Return Estimation, TODAY(<7)

Thank you for any help!

Isis Taylor

@rbattista Got it. This works on my sheet.

=COUNTIFS([Start Date]:[Start Date], >=TODAY(), [Start Date]:[Start Date], @cell <= TODAY() + 7)

Isis Taylor

@rbattista Try it this way.

=COUNTIF([Off-Site to On-Site Return Estimation]:[Off-Site to On-Site Return Estimation], (@cell > TODAY (-7)))

rbattista

@Isis Taylor, still Unparsable, weird!

Isis Taylor

Are you trying to determine if the date within the off-site cell is less than a week from the current date (Today's Date)?

rbattista

@Isis Taylor I'm trying to determine if the date in the cell is 7 days away, so in a way, yes! I just need to count the number of cells that have a date that is approaching.

Isis Taylor

@rbattista Got it. This works on my sheet.

=COUNTIFS([Start Date]:[Start Date], >=TODAY(), [Start Date]:[Start Date], @cell <= TODAY() + 7)

rbattista

@Isis Taylor, that worked for me too! Thank you so much!