Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
![]()
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 | |||
formula to look at current date and markdown date to give price | Excel Discussion (Misc queries) | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) |