Results 1 to 6 of 6

How to calculate between Years, Months and date by the given criteria

Threaded View

  1. #1
    Registered User
    Join Date
    09-12-2014
    Location
    Pune, India
    MS-Off Ver
    2003 & 2010
    Posts
    5

    How to calculate between Years, Months and date by the given criteria

    Hi,
    I am working for Jail authorities in India and have an issue with automating the calculation of prisoner’s release. The criteria is like the prisoner does not get any remission for his under trail days, once he is convicted than he starts getting remission for 7 days a month, i.e he needs to work for the entire month starting form 1st of the month till the last date. If he is convicted on any other day apart from the 1st of any month he does not get any remission. The second criteria is if he completes the entire calendar year without any leave he gets one more month of remission i.e 30 days. How to automate it. We are currently doing manual calculations for it
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate age between date/year and now to include months ie. 2.3 years
    By micko_escalade in forum Excel General
    Replies: 10
    Last Post: 04-18-2016, 06:34 PM
  2. Replies: 8
    Last Post: 02-20-2014, 05:46 PM
  3. Excel 2007 : Calculate years, months, day
    By helpme16 in forum Excel General
    Replies: 10
    Last Post: 01-18-2011, 12:34 AM
  4. Replies: 1
    Last Post: 06-29-2006, 09:30 AM
  5. Calculate number of years and months employed using hire date and.
    By TryingTime in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-28-2006, 11:30 PM
  6. [SOLVED] HOW DO YOU CALCULATE AGE BY DATE OF BIRTH I NEED YEARS AND MONTHS
    By dallyup2 in forum Excel General
    Replies: 2
    Last Post: 02-28-2006, 04:25 PM
  7. calculate date differences in years and months
    By Joyce in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2005, 02:06 PM

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