+ Reply to Thread
Results 1 to 5 of 5

How to compute the number of days between a given date(fomat) against today date

  1. #1
    Registered User
    Join Date
    03-17-2017
    Location
    Sngaproe
    MS-Off Ver
    MS 2010
    Posts
    2

    How to compute the number of days between a given date(fomat) against today date

    Example of the given date is 28.02.2017(from extracted data in Excel sheet)

    What is the Excel coding to compute the number of days between a given date(fomat) against today date?

    Thank you.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,220

    Re: How to compute the number of days between a given date(fomat) against today date

    Welcome to the forum!

    With your date in A1:

    =ABS(TODAY()-A1)

    This will work for dates that have passed and dates in the future.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,864

    Re: How to compute the number of days between a given date(fomat) against today date

    If the above do not work - then probably the "date" is not an excel date but just text which only looks as a date.
    then try more complicated formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    PS. if the output looks as date (say: Jan 18, 1900) set the format of the cell with te formula to General.
    Best Regards,

    Kaper

  4. #4
    Registered User
    Join Date
    03-17-2017
    Location
    Sngaproe
    MS-Off Ver
    MS 2010
    Posts
    2

    Smile Re: How to compute the number of days between a given date(fomat) against today date

    The formula is working good.
    Thanks a lot!

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,220

    Re: How to compute the number of days between a given date(fomat) against today date

    You're welcome!.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate number of days between invoice date and today's date
    By JHerrick in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-30-2020, 03:53 PM
  2. calculate number of days between a date and today
    By South texas man in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-20-2020, 04:58 PM
  3. testing if one date exceeds today's date by a specific number of days with vba
    By Dana_Carter in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-08-2016, 07:49 PM
  4. Replies: 4
    Last Post: 02-28-2016, 06:09 PM
  5. Replies: 4
    Last Post: 05-08-2014, 10:13 AM
  6. create a macro to alert me if today's date is within 5 days of expected delivery date
    By ashmcclure in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 09-25-2008, 05:51 PM
  7. [SOLVED] Date Function:compute the total number of days
    By MARK XU in forum Excel General
    Replies: 2
    Last Post: 01-09-2006, 05:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1