RESULT BEETWEEN TWO DATES

[Sara_Bertomeu]

Hello friends and Angels, 

I need to find the result from two dates, know the days from check in (01/01/2022) and check out (15/02/2022). 

How can I find it?

Some similar to:

Show More

=IFS((

H5="cancelled_by_guest");0;

H5="cancelled_by_hotel";0;

H5="OK";(DAYS(E5;D5)/24))

This result is 1:00:00 but I need "1, 2, 3" for days

I saw https://support.google.com/appsheet/answer/10107326?hl=en

and I cann't find it.

Thanks Sara

[Suvrutt_Gurjar · Accepted solution]

Typically days between two dates in AppSheet are given by the expression 

HOUR([Check Out]-[Check in])/24

where [Check Out] and [Check in] are date type columns.

Please refer the example 

HOUR(TODAY() - [TargetDate]) / 24

in the date and time article you have shared under the section "Examples that compute Durations in Days, Months, or Years"

 https://support.google.com/appsheet/answer/10107326?hl=en

[Suvrutt_Gurjar · Accepted solution]

Typically days between two dates in AppSheet are given by the expression 

HOUR([Check Out]-[Check in])/24

where [Check Out] and [Check in] are date type columns.

Please refer the example 

HOUR(TODAY() - [TargetDate]) / 24

in the date and time article you have shared under the section "Examples that compute Durations in Days, Months, or Years"

 https://support.google.com/appsheet/answer/10107326?hl=en

[Ccuadros · Accepted solution]

HOUR([CHECK_OUT] - [CHECK_IN]) / 24 : number of days between check out's date and the check in value.

[Sara_Bertomeu]

Thanks boys,