May 12 2022 12:52 AM
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 of full days that has lapsed since that date and time.
Thanks,
Bryan
May 12 2022 01:22 AM
@Bryantotalis Let's say that date/time is in A1, the following formula will calculate the number of days (in decimals) lapsed till now. Round it to your liking and format the cell as General or Number as it will spit out a date/time value.
=(NOW()-A1)
May 12 2022 01:24 AM
Let's say the date/time is in A2.
The number of 24-hour periods since that date/time is =INT(NOW()-A2)
May 12 2022 01:28 AM
May 12 2022 01:30 AM
May 12 2022 01:38 AM
@Bryantotalis That number represents todays date, which would be the result of =NOW()-0
What exactly did you enter?
May 12 2022 01:42 AM
May 12 2022 01:52 AM
@Bryantotalis Whatever you have in G1, it represents zero. Can you upload a screenshot or share the file via OneDerive, Dropbox etc.