In article <0a5b5648-5d01-466e-87ef-6a37733564acn@googlegroups.com>, Emma Rayment wrote...
Hi there,
I am looking for help to figure out the formula that would help me count how many rows in a column have a date that is within the next 90 days?
Column: Renewal Date
Row: 1/2/23
I want to have a total sum at the bottom that will count the number of accounts I have that are up for renewal within the next 90 days.
Thanks
If you want to count the number of cells in a range which meet a particular criterion, then the COUNTIF formula seems appropriate. (For more than one criterion, use COUNTIFS.)
For your criterion, you'd want to compare the date in the cell with the resut of the TODAY() function.
Have a look at this:
https://www.ablebits.com/office-addins-blog/excel-countif-function-examples/ #countif-dates
Hi there,
I am looking for help to figure out the formula that would help me count how many rows in a column have a date that is within the next 90 days?
Column: Renewal Date
Row: 1/2/23
I want to have a total sum at the bottom that will count the number of accounts I have that are up for renewal within the next 90 days.
Thanks
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 298 |
Nodes: | 16 (2 / 14) |
Uptime: | 10:52:32 |
Calls: | 6,677 |
Files: | 12,219 |
Messages: | 5,340,628 |