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)),"")