jwbrouse01
New Member
- Joined
- Jun 2, 2022
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Greetings,
How can I create a countif/ifs formula that will count based on datestamp?
In column A of Sheet1, I have a list of datestamps as below.
9/5/2023 9:59:04 PM
I want to create a countif/ifs formula on another sheet that will count for each day running from 10:00 pm to 10:00 pm, i.e., data on 9/5 @ 10:05 pm actually counts toward 9/6.
If possible, I need to do this without manipulating the data in Sheet1. I want the user to be able to just copy data into Sheet1 and the data is displayed.
Can someone please assist me?
Thank you!
How can I create a countif/ifs formula that will count based on datestamp?
In column A of Sheet1, I have a list of datestamps as below.
9/5/2023 9:59:04 PM
I want to create a countif/ifs formula on another sheet that will count for each day running from 10:00 pm to 10:00 pm, i.e., data on 9/5 @ 10:05 pm actually counts toward 9/6.
If possible, I need to do this without manipulating the data in Sheet1. I want the user to be able to just copy data into Sheet1 and the data is displayed.
Can someone please assist me?
Thank you!