Sep 04 2021 06:40 AM
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.
Sep 04 2021 06:50 AM
To calculate difference in days it's just = end - start (=A2-A1)
Sep 06 2021 04:19 PM
44446 is the serial number for 9/6/2021
44445 is the serial number for 9/5/2021
=44446-44445
or
or
Sep 06 2021 04:30 PM