Asking for assistance: calculating a time difference

Copper Contributor

I have to calculate time gaps between a starting date and an end date. I have found the formula =DATEDIF (start, end,"d") which is supposed to calculate the disered time gap in days.

But all I get is an error message.

I ` running WINDOWS 10 PRO, Version 20H2

 

Thanks for any helpful advice.

 

3 Replies

@MEAKMUC 

To calculate difference in days it's just = end - start (=A2-A1)

@MEAKMUC 

 

44446 is the serial number for 9/6/2021

44445 is the serial number for 9/5/2021

=44446-44445

or

Yea_So_0-1630970211152.png

or

Yea_So_1-1630970323408.png

DATEDIF function (microsoft.com)

@MEAKMUC 

 


@MEAKMUC wrote:

But all I get is an error message.

Ah, the famous error message.