Forum Discussion
Day count funtion
Hi, Just wondering how i write a command that will calculate the number of days from a given date and time. Example - I have a cell containing 02/04/2022 14:13:47 . I wish to calculate the number o...
Let's say the date/time is in A2.
The number of 24-hour periods since that date/time is =INT(NOW()-A2)
I tried that with 02/05/2022 14:13:47 and it gave me an answer of 44693.