Kemidan2014
Board Regular
- Joined
- Apr 4, 2022
- Messages
- 226
- Office Version
- 365
- Platform
- Windows
I am needing to count by several criteria,
I have used the function Today()-90>=M2 in a formula before in IF statements to get True False value
but essentially i need to add criteria to a COUNTIFS formula where i want it to count if the date in the column of data is >= todays date - 90 days meaning any dates that are older than 90 days
but using Countifs(<Cellrange here>,">=Today()-90",<Cellrange here>,... ) is not accepting. can i not use Today() in a countifs? what other syntax could i use?
I have used the function Today()-90>=M2 in a formula before in IF statements to get True False value
but essentially i need to add criteria to a COUNTIFS formula where i want it to count if the date in the column of data is >= todays date - 90 days meaning any dates that are older than 90 days
but using Countifs(<Cellrange here>,">=Today()-90",<Cellrange here>,... ) is not accepting. can i not use Today() in a countifs? what other syntax could i use?