+ Reply to Thread
Results 1 to 10 of 10

Subtracting Dates

  1. #1
    Forum Contributor
    Join Date
    05-20-2009
    Location
    Galway, Ireland
    MS-Off Ver
    Excel 2003
    Posts
    148

    Subtracting Dates

    Hey guys,

    I've a spreadsheet here in Excel 2010 which I'm populating with a table outputted from another program. One of the columns in it will be a list of dates (in american format though!). What I need is a function which looks at this date and returns the difference between this and the current date in days (rounded to whole number is fine)
    Is it the DATE360 function I need for this?
    Cheers!
    Manolis

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Subtracting Dates

    Hi Manolis( Are you Greek?)

    You can use simple this(With your date in A1)

    =A1-TODAY()


    Format, as General.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: Subtracting Dates

    look @

    = DATEDIF ( start_date , end_date , unit )
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  4. #4
    Forum Expert
    Join Date
    09-27-2011
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    1,312

    Re: Subtracting Dates

    maybe use: =today()-A1
    A1 your date
    or
    =ROUND(today()-A1,0)
    Regards

    tom1977

    If You are satisfied with my solution click the small star icon on the left to say thanks.

  5. #5
    Forum Contributor
    Join Date
    05-20-2009
    Location
    Galway, Ireland
    MS-Off Ver
    Excel 2003
    Posts
    148

    Re: Subtracting Dates

    Hi Fotis!

    I'm half Greek! Born in Kavala and lived on Thassos for my first couple of years but have been in Ireland since. I'll be going over again in September hopefully!
    I like your comments about the politicians!

    Unfortunatly all the functions suggested are returning a #VALUE error.
    Is this Excel not recognising my date from the pasted-in table as the functions seem to make sense?

  6. #6
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Subtracting Dates

    Μανώλη(Manolis), Must be some format problem in your data.

    All suggested formulae must work for you!

    Upload a small sample workbook to take a look there.

    *So, we'll wait you back to Greece in September..

  7. #7
    Forum Contributor
    Join Date
    05-20-2009
    Location
    Galway, Ireland
    MS-Off Ver
    Excel 2003
    Posts
    148

    Re: Subtracting Dates

    Practice Sheet.xlsx

    Here you go.
    It's definately the format issue as a few of them do work. But these are being read as European date format

  8. #8
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Subtracting Dates

    Manolis, is real strange..... I can not understand what happens...

    I'll keeping looking for a while...

    Hope, someone else to have a good idea about this........

  9. #9
    Forum Expert
    Join Date
    09-27-2011
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    1,312

    Re: Subtracting Dates

    Hi select columns with dates and usy text to columns click 2 times "next" then choose date and set this on MDY and "Finish"

  10. #10
    Forum Contributor
    Join Date
    05-20-2009
    Location
    Galway, Ireland
    MS-Off Ver
    Excel 2003
    Posts
    148

    Re: Subtracting Dates

    Thanks Tom,

    That what it was!

    And thanks to everyone else too!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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