Forum Discussion

Bryantotalis's avatar
Bryantotalis
Copper Contributor
May 12, 2022

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...
excel
Formulas and Functions
Bryantotalis's avatar
Bryantotalis
Copper Contributor
May 12, 2022
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.
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 12, 2022

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

 

What exactly did you enter? 

  • Bryantotalis's avatar
    Bryantotalis
    Copper Contributor
    May 12, 2022
    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

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      May 12, 2022

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

      • Bryantotalis's avatar
        Bryantotalis
        Copper Contributor
        May 12, 2022
        Got it. Thanks

Resources