+ Reply to Thread
Results 1 to 4 of 4

how to use datedif

  1. #1
    Registered User
    Join Date
    08-13-2014
    Location
    Phil
    MS-Off Ver
    2007
    Posts
    21

    Exclamation how to use datedif

    Hi guys,
    on this scenario im trying to learn the functionality of datedif on how I can implement this. Right now im trying to make a computation regarding time allowance of inmates. by the way time allowance is something that can be use be used to deduct the lenght of stay of inmates. So here's the format:

    samples:
    Start date Saturday, June 01, 2013
    Penalty: 20 years 1 months 3 days
    Expected release date Wednesday, July 04, 2033

    Actual Time served 5 Years 2 months 1 days
    Time allowance 6 years 8 months 0 days
    Release date with time allowance: ?
    Remaining days of stay in jail: ?

    please see attach file it seems that there is a an error on the calculation
    Attached Files Attached Files
    Last edited by Enigma Trio; 11-17-2014 at 03:30 AM. Reason: additional attachment to see

  2. #2
    Registered User
    Join Date
    08-13-2014
    Location
    Phil
    MS-Off Ver
    2007
    Posts
    21

    Re: how to use datedif

    in need of assistance, pls help me out here.

  3. #3
    Registered User
    Join Date
    08-13-2014
    Location
    Phil
    MS-Off Ver
    2007
    Posts
    21

    Re: how to use datedif

    sori, that was an edate format sent by sum one in this thread.

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

    Re: how to use datedif

    Changed your Edate formula to Date formula

    In B6 Cell

    =B4+DATE(B5,0,0)


    In B12 Cell


    =B6-DATE(B11,D11,F11)



    Refer the attached file
    Attached Files Attached Files


    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. DateDif Average? Damn DateDif
    By UTCHELP in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-10-2012, 08:53 AM
  2. Excel 2007 : Datedif
    By mick2 in forum Excel General
    Replies: 2
    Last Post: 06-14-2010, 07:44 PM
  3. DateDif
    By vandanavai in forum Excel General
    Replies: 4
    Last Post: 01-30-2007, 12:42 PM
  4. Help with datedif
    By nickbelmont in forum Excel General
    Replies: 3
    Last Post: 11-27-2006, 01:03 PM
  5. [SOLVED] DATEDIF
    By Deborah in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-13-2006, 08:05 AM

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