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...
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?
- I have a cell with 02/05/2022 14:13:47 in it. I then entered =INT(NOW()-G1) which gave me 44693
I then tried =(NOW()-G1) which gave me 44693.40
