+ Reply to Thread
Results 1 to 5 of 5

Date - Date = x Days formula

  1. #1
    Ernest Lai
    Guest

    Date - Date = x Days formula

    Good morning all,

    I have a spreadsheet with a list of days. And i would like to create a
    formula so it reads something like.

    Today (read off the computer or manually typed in) - 31/01/06 = 28

    Is this at all possible?

  2. #2
    Ernest Lai
    Guest

    RE: Date - Date = x Days formula

    i have tried using the

    =today() function but it doesnt seem to work as intended in the help file :/

    "Ernest Lai" wrote:

    > Good morning all,
    >
    > I have a spreadsheet with a list of days. And i would like to create a
    > formula so it reads something like.
    >
    > Today (read off the computer or manually typed in) - 31/01/06 = 28
    >
    > Is this at all possible?


  3. #3
    Gary''s Student
    Guest

    RE: Date - Date = x Days formula

    Put your date in A1 and =today() in B1 and =DATEDIF(A1,B1,"d") in C1
    --
    Gary's Student


    "Ernest Lai" wrote:

    > Good morning all,
    >
    > I have a spreadsheet with a list of days. And i would like to create a
    > formula so it reads something like.
    >
    > Today (read off the computer or manually typed in) - 31/01/06 = 28
    >
    > Is this at all possible?


  4. #4
    Roger Govier
    Guest

    Re: Date - Date = x Days formula

    Hi Ernest
    =TODAY()-"31/01/06"
    You need to format the cell with the formula as General, then it will
    show 28.
    It will probably be showing 28/01/1900, as it will have picked up a date
    format.

    --
    Regards

    Roger Govier


    "Ernest Lai" <[email protected]> wrote in message
    news:[email protected]...
    >i have tried using the
    >
    > =today() function but it doesnt seem to work as intended in the help
    > file :/
    >
    > "Ernest Lai" wrote:
    >
    >> Good morning all,
    >>
    >> I have a spreadsheet with a list of days. And i would like to create
    >> a
    >> formula so it reads something like.
    >>
    >> Today (read off the computer or manually typed in) - 31/01/06 = 28
    >>
    >> Is this at all possible?




  5. #5
    Ernest Lai
    Guest

    Re: Date - Date = x Days formula

    O LOL - i really need to wake up. That was perfect thanks. I actually went
    and changed the format of the cell so it would get rid of the time 00:00.

    thanks a lot for the replies :D

    "Roger Govier" wrote:

    > Hi Ernest
    > =TODAY()-"31/01/06"
    > You need to format the cell with the formula as General, then it will
    > show 28.
    > It will probably be showing 28/01/1900, as it will have picked up a date
    > format.
    >
    > --
    > Regards
    >
    > Roger Govier
    >
    >
    > "Ernest Lai" <[email protected]> wrote in message
    > news:[email protected]...
    > >i have tried using the
    > >
    > > =today() function but it doesnt seem to work as intended in the help
    > > file :/
    > >
    > > "Ernest Lai" wrote:
    > >
    > >> Good morning all,
    > >>
    > >> I have a spreadsheet with a list of days. And i would like to create
    > >> a
    > >> formula so it reads something like.
    > >>
    > >> Today (read off the computer or manually typed in) - 31/01/06 = 28
    > >>
    > >> Is this at all possible?

    >
    >
    >


+ 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