# Day count funtion

Occasional Contributor

# 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

8 Replies

# Re: Day count funtion

@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)

# Re: Day count funtion

Let's say the date/time is in A2.

The number of 24-hour periods since that date/time is =INT(NOW()-A2)

# Re: Day count funtion

I tried that with 02/05/2022 14:13:47 and it gave me an answer of 44693.

# Re: Day count funtion

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.

# Re: Day count funtion

@Bryantotalis That number represents todays date, which would be the result of =NOW()-0

What exactly did you enter?

# Re: Day count funtion

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

# Re: Day count funtion

@Bryantotalis Whatever you have in G1, it represents zero. Can you upload a screenshot or share the file via OneDerive, Dropbox etc.

Got it. Thanks