Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
hi,
i've built a loan amortization schedule with payments due semi-annually. my problem is that the payment must be on the same day of the 6th and 12th month. for example payments due 2/12/05 and 8/12/05 or 9/23/05 and 3/23/06. the problem is that months have 30 or 31 days and then there's february and leap years too. is there a way to program this function so that manual entry payment dates can be eliminated? tia dennis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Formula | Excel Discussion (Misc queries) | |||
Date formula | Excel Discussion (Misc queries) | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) |