STEVENS3010
Board Regular
- Joined
- Feb 4, 2020
- Messages
- 89
- Office Version
- 365
- 2016
- Platform
- Windows
Hi all,
Could somebody please help me with a formula. I have a range of data in column A (dates & times - e.g. 01/01/2021 9:00am)
I have a table of dates in a separate part of the sheet, and I'm looking for a formula to look up the value in the table e.g. "01/01/2021" in cell "S2" for example and to then count the number of times this date is in the range of data in column A. The issue is I only need to count the date part of the info in column A, not the time. Is it possible to use a countif formula with a partial match on time/date? i.e - can I only count the "01/01/201" part of the example in the first line?
Could somebody please help me with a formula. I have a range of data in column A (dates & times - e.g. 01/01/2021 9:00am)
I have a table of dates in a separate part of the sheet, and I'm looking for a formula to look up the value in the table e.g. "01/01/2021" in cell "S2" for example and to then count the number of times this date is in the range of data in column A. The issue is I only need to count the date part of the info in column A, not the time. Is it possible to use a countif formula with a partial match on time/date? i.e - can I only count the "01/01/201" part of the example in the first line?