+ Reply to Thread
Results 1 to 3 of 3

Datedif function

  1. #1
    Registered User
    Join Date
    11-30-2013
    Location
    Dubai
    MS-Off Ver
    Excel 2007
    Posts
    1

    Datedif function

    the datedif function [=datedif(<startdate>, <enddate>, "d")] is not working in my excell 2007. cud any1 can help me to solve this or is der any other function available in excel 2007.

    thans
    vinod

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Datedif function

    Hi,

    if you' d need only days difference using

    =B1-A1

    you get same number.

    If you can kindly upload a sample file with an example of the problem you are dealing with, I could be more precise in helping you.

    Regards
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Datedif function

    Press Alt+T+I and and give tick mark in Analysis ToolPak and give ok...

    After enabling it try the formula


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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. Using DateDif function
    By ac20402 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2010, 04:59 PM
  2. #NUM! while using DATEDIF function
    By sriradh in forum Excel General
    Replies: 3
    Last Post: 08-22-2008, 03:21 PM
  3. DateDif Function
    By The Muffin Man in forum Excel General
    Replies: 2
    Last Post: 09-06-2007, 06:35 PM
  4. [SOLVED] Datedif function
    By shaji in forum Excel General
    Replies: 2
    Last Post: 05-13-2006, 09:40 AM
  5. [SOLVED] how do I get access to the datedif function?
    By Joe McLain in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-03-2006, 04:25 PM

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