Using a Relative Date in COUNTIFS Formula

Jess Motyl-Szary

I'm looking to use a relative date in my COUNTIFS formula (ex: In the next 7 days). This needs to be evergreen so I don't have to be updating the dates every day to have an accurate count so I need a relative date functionality rather than using a lesser than-greater than formula.

Alexander Ford

Hi Jess,

In these situations I like to create today COUNTIF formulas that use the TODAY() function. Combined with any number of other functions that can interact with it (such as NETWORKDAYS, AND, OR, other conditionals, etc. No need to make any manual updates to formulas like that. Do you think that will work? If you show us what you're working on I could try building out an example with your data.

Thanks,

Alex

Alexander Ford

Hi Jess,

In these situations I like to create today COUNTIF formulas that use the TODAY() function. Combined with any number of other functions that can interact with it (such as NETWORKDAYS, AND, OR, other conditionals, etc. No need to make any manual updates to formulas like that. Do you think that will work? If you show us what you're working on I could try building out an example with your data.

Thanks,

Alex