Home |
Search |
Today's Posts |
#1
|
|||
|
|||
future dates
Current formulas calculate a Monthly and Weekly future pay-off date. I'm
wondering if there is a way to calculate a bi-weekly date? =EDATE(C20,NPER(0,C15,C10)*-1) Monthly Date =((CEILING(H10/H15,1)-1)*7+H20) Weekly Date Balance $5000.00 Payment $34.00 Begin Date 7/11/05 End Date ? End date will need to be based on a bi-weekly calculation. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
future dates | Excel Worksheet Functions | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
How can I hide points for future dates on a Year to Date chart? | Charts and Charting in Excel |