Forum Discussion

excel101's avatar
excel101
Copper Contributor
Jun 21, 2019
Solved

Date calculation formula needed for daily pickup

Hello Experts, I am looking for a formula that calculates daily numbers from check-in and check-out dates. I am aware of the basic formula that calculates the total number of days between two dates ...
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Jun 21, 2019
It appears that the check-in date is included in, while the check-out date is excluded from, the calculation of total nights. Thus, the formula in E2, copied down rows and across columns, is:
=IF((E$1>=$A2)*(E$1<$B2),
1,””)
excel101's avatar
excel101
Copper Contributor
Jun 21, 2019

TwifooThank you so much! It worked!

Resources