+ Reply to Thread
Results 1 to 4 of 4

No. of days

  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    2

    No. of days

    I'm a new member to this E- Forum, and happy to be here.
    I would like to know the formula which generate number of days passed for a list of items as per today:
    e.g sales of 12/03/2013
    Stock of 20/4/2013
    how many days from each date as per today date.
    thanks

  2. #2
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: No. of days

    Please Login or Register  to view this content.
    A1= your start day.
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++

  3. #3
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: No. of days

    Hi
    this formular will calculate the number of days between today and the date value in cell A1, is that what you need?

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    07-11-2013
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: No. of days

    thanks, I will try it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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