+ Reply to Thread
Results 1 to 3 of 3

Finding Number of Days from Previous Date

  1. 11-23-2020, 02:31 PM #1
    anonymous321
    anonymous321 is offline
    Forum Contributor
    Join Date
    07-19-2017
    Location
    usa
    MS-Off Ver
    2016 Professional Plus
    Posts
    128

    Finding Number of Days from Previous Date

    Hi,
    I have attached an excel file where column A shows the date. I want to calculate the number days from today to that date. Secondly, whenever I open the sheet, then it should take today's date and calculate the number of days to the date in column A.

    I hope you understand the problem. Let me know about your thoughts if that is something we can easily do it.


    Thanks and Best Regards,
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-23-2020, 02:37 PM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Finding Number of Days from Previous Date

    Please try at B2
    =TODAY()-TRIM(MID(A2,FIND(",",A2)-2,2)&REPLACE(A2,FIND(",",A2)-2,3,))
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  3. 11-23-2020, 03:33 PM #3
    anonymous321
    anonymous321 is offline
    Forum Contributor
    Join Date
    07-19-2017
    Location
    usa
    MS-Off Ver
    2016 Professional Plus
    Posts
    128

    Re: Finding Number of Days from Previous Date

    Thanks alot. The formula works perfectly
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Finding Previous value and that row number
    By AV114 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-20-2018, 01:06 PM
  2. Help With Calculating Number of Previous Days
    By BizProcessGuy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2017, 12:52 PM
  3. [SOLVED] Finding number of days between dates and categorising by week ending date
    By benoj2005 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2016, 07:42 AM
  4. Asking for previous date plus two days
    By KJBrown in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-21-2014, 10:02 AM
  5. [SOLVED] Number of days in previous month
    By Tortus in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 07-01-2014, 11:23 AM
  6. Finding future date given the number of days
    By kabatak in forum Excel General
    Replies: 2
    Last Post: 05-14-2007, 12:59 PM
  7. In excel,how do I change the date to a date 84 days from previous
    By Alister Edmond in forum Excel General
    Replies: 3
    Last Post: 02-09-2006, 10:30 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1