Thread: Need a formula
View Single Post
  #1   Report Post  
old coach old coach is offline
Junior Member
 
Posts: 14
Question Need a formula

I can calculate the expiration date manually, but I need a formula. I use the information constantly but don't know how to set it up in excel.

John Doe's parole expires on 2/1/2008.
Each month on the 9th the parole date is reduced by 6 days.
If his parole expires before the 9th of the month, he will get 6 days on the 20th of the previous month.
When will John Doe's parole expire?
***the 6 represents a variable. It could be a 10, 12, 16 , 6****
The correct answer, calculated manually using the 6 is 12-27-2007.

//////////////////////////////////
The above does not work if I extend the start date to 2/1/2010 and change the compensation to 16.
The correct answer should be 9-26-2009.

Last edited by old coach : February 27th 09 at 03:05 AM Reason: won't work with changes.