+ Reply to Thread
Results 1 to 2 of 2

Date Result

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    36

    Date Result

    Hi Guys,

    I have a question i have date in column B "IGR-02282014-10385",
    the bold ones is the date. Now what i want is to add the 40 days in that date and then in one column it will tell me from 40 days how many days left

    Like that:

    for example:

    IGR-02282014-10385

    for over there the date is 02282014+40=04/09/2014

    Today is 03/20/2014.

    So it will show me 20 days left.

    Can you guys help me in that?

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Date Result

    With
    A1 containing your source text
    This regular formula returns the number of days remaining until the embedded date plus 40 days
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ 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. date value of a column and then get result
    By mubashar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2014, 05:14 AM
  2. Deference Between Two Date and result in a year
    By midoo77 in forum Excel General
    Replies: 5
    Last Post: 02-10-2013, 07:26 PM
  3. [SOLVED] Calculate the nearest date to the result date
    By SuzanneG in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2012, 04:32 AM
  4. [SOLVED] Yes/No Result if a date value falls 'In Hours'
    By Flydd in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-03-2012, 02:26 PM
  5. Can Excel add working days to a date to result in another date?
    By cwalrus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2006, 02:35 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