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 of full days that has lapsed since that date and time.
Thanks,
Bryan
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.
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)
- I tried that with 02/05/2022 14:13:47 and it gave me an answer of 44693. My existing cell is set as general.
Bryantotalis That number represents todays date, which would be the result of =NOW()-0
What exactly did you enter?
