Excel Magic Trick #151: DATEDIF function (between two dates)

Sir, i work in a hospital and would like to request a video, where u can teach us a formula to calculate number of patient readmissions based on the last date they got discharge please. Many Thanks.

Beautiful 😍✨❤

How to find defrence between two date in year and day in one cell

=Datedif(Start date,end date,"y")&-Datedif(Start date,end date,"ym")&-Datedif(Start date,end date,"md")
Ye Wala formula lgao or age aik cell main pao

Is is "dated-if" or "date-dif", as in, difference between dates?

Datedif doesn't work for me

Im cofused!. where are mo. and where are days here? is it an American system?

A Sq

When i was doing that my answer is not coming even i am doing corrct

Woah a super old excel video is the most helpful thing I've found for this problem on excel 365 that I just haven't been able to solve.

literally didnt help. thanks for ttrying

Why there is more than 30 days in column O. Anybody Pl expalin. Also explain how to remove this discrepency.

thanks a bunch. Was looking for this for a long time. Was stuck at work trying to figure this out

It's not "Dated if", it's "Date dif".

G

ع

what about weeks?

dude you just saved my job

hai,
This formula is showing wrong days in 2020 year.
14/05/2007 09/01/2020 12 151 4623 139 7 353 151 months & 139 days 12 years & 353 days
.
how to rectify this error.