Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |