Results 1 to 4 of 4

Thread: Formula help - Excel Masters - Time

  1. #1

    Formula help - Excel Masters - Time



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I need a formula which generates a whole number that expresses: How many days from the current date you open spreadsheet to the date in a given cell.

    Possible? Thanks excel masters!

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by cmccambridge123 View Post
    How many days from the current date you open spreadsheet to the date in a given cell.
    Try
    Code:
    =DATEDIF(A1,TODAY(),"md")

  3. #3
    Acolyte candybg's Avatar
    Join Date
    Jul 2015
    Posts
    92
    Articles
    0
    Excel Version
    2010 and 2016
    I think the OP was looking for this formula, but with a "D" in quotes, not "MD".
    Code:
    =DATEDIF(A1,TODAY(),"D")

  4. #4
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by candybg View Post
    but with a "D" in quotes, not "MD".
    Thanks for the correction
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •