+ Reply to Thread
Results 1 to 7 of 7

how to make a formula in remaining days

  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    7

    how to make a formula in remaining days

    hello guys pls if you could help with this one. how to make a formula with the remaining days.
    ex. verification date due date remaining days
    1/1/2013 3/1/2013 ?

  2. #2
    Forum Expert 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: how to make a formula in remaining days

    =B1-A1

    Formt the result cell 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
    Registered User
    Join Date
    01-24-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: how to make a formula in remaining days

    thanks but it counts how many days from the start date to end date. what i mean is remaining days left.
    Quote Originally Posted by Fotis1991 View Post
    =B1-A1

    Formt the result cell as General.

  4. #4
    Forum Expert 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: how to make a formula in remaining days

    By remaining days, do you mean the days between Today and your second date?

    If NO, pls explain which is the result that you expect using your example in your first post.

  5. #5
    Registered User
    Join Date
    01-24-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: how to make a formula in remaining days

    yes thats it.
    Quote Originally Posted by Fotis1991 View Post
    By remaining days, do you mean the days between Today and your second date?

    If NO, pls explain which is the result that you expect using your example in your first post.

  6. #6
    Forum Expert 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: how to make a formula in remaining days

    =b1-today()

  7. #7
    Registered User
    Join Date
    01-24-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: how to make a formula in remaining days

    thanks.....
    Quote Originally Posted by Fotis1991 View Post
    =b1-today()

+ 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