STEVENS3010
Board Regular
- Joined
- Feb 4, 2020
- Messages
- 87
- Office Version
- 365
- 2016
- Platform
- Windows
Hi all,
I have a spreadsheet where one of the columns contains a list of dates and I'm looking for a formula to count any dates more than one day prior.
For example... I have =today in cell a1 and it displays 28/03/2021 (today's date). In Column B I have a list of dates (example below) and I need a formula to count any dates more than one day prior i.e. anything before 27/03/2021. Is this possible?
Example List:
28/03/2021
01/03/2021
25/02/2021
16/02/2021
I have a spreadsheet where one of the columns contains a list of dates and I'm looking for a formula to count any dates more than one day prior.
For example... I have =today in cell a1 and it displays 28/03/2021 (today's date). In Column B I have a list of dates (example below) and I need a formula to count any dates more than one day prior i.e. anything before 27/03/2021. Is this possible?
Example List:
28/03/2021
01/03/2021
25/02/2021
16/02/2021