San Antonio Heat
Active Member
- Joined
- Oct 10, 2003
- Messages
- 333
- Office Version
- 2019
- Platform
- Windows
Hi all,
I have dates in two columns, sheet1 A and B
On Sheet 2, I would like to count all the days that are equal to or within a day (+1)
Example Sheet 1
A1: 3/1/21 B1: 3/2/21
A2: 3/1/21 B2: 3/15/21
A3: 3/2/21 B3: 3/2/21
A4: 3/2/21 B4: 3/3/21
A5: 3/3/21 B5: 3/22/21
Sheet 2
A1 (formula) should equal 3
Thanks all.
I have dates in two columns, sheet1 A and B
On Sheet 2, I would like to count all the days that are equal to or within a day (+1)
Example Sheet 1
A1: 3/1/21 B1: 3/2/21
A2: 3/1/21 B2: 3/15/21
A3: 3/2/21 B3: 3/2/21
A4: 3/2/21 B4: 3/3/21
A5: 3/3/21 B5: 3/22/21
Sheet 2
A1 (formula) should equal 3
Thanks all.