Home |
Search |
Today's Posts |
#1
|
|||
|
|||
future dates
=H20+7*NPER(0,H15,H10)*-1
Weekly Total Due $745.00 Weekly Payment $34.00 Begin Date 7/11/05 End Date I'm looking for this formula to always end on the same day (mon,tue, etc.) as it began. For example 7/11 is a Monday and I need it to end on a Monday in the future. If I were to run the formula now, it would end on 12/11 a Tuesday. Is there a way to have it end on a Monday even though it will be a partial payment? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
due dates | New Users to Excel | |||
How can I hide points for future dates on a Year to Date chart? | Charts and Charting in Excel |