Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date Format
What I want to know, is I have a loan Calculator. i want it to give me days
in a week, where as it currently show 1 date a month repeated for the number of week for the month This is what it showing at the moment, This is what I want it to show 19/02/2005 19/02/2005 19/02/2005 26/02/2005 19/02/2005 5/03/2005 19/02/2005 12/03/2005 19/03/2005 19/03/2005 19/03/2005 26/03/2005 19/03/2005 2/04/2005 19/03/2005 9/04/2005 19/04/2005 16/04/2005 19/04/2005 23/04/2005 It's fine for 12 monthly payments but not for weekly, this is the fomula used need to know how to change =IF(Pay_Num<"",DATE(YEAR(Loan_Start),MONTH(Loan_S tart)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),"") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
Customized Date Format | Excel Worksheet Functions | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) |