adding changing number of days
 

Hello,
Bank calculates loan repayment due dates like this:
1 181 day from drawdawn day
2 184 days from previous payment day
3 181 days from previous payment day
4 184 days from previous payment day
5 181 days from previous payment day
and so on
....
How can I make formula or macro add to previous date one time 181
days, next time 184 days and so on again in order to get the dates
when payments are due?

Excel 2000/XP, Win 2000/XP

Thank you very much

Aivars

adding changing number of days
 

one way would be to store the variable in a cell somewhere & use an if
statement

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Aivars" wrote in message
om...
Hello,
Bank calculates loan repayment due dates like this:
1 181 day from drawdawn day
2 184 days from previous payment day
3 181 days from previous payment day
4 184 days from previous payment day
5 181 days from previous payment day
and so on
...
How can I make formula or macro add to previous date one time 181
days, next time 184 days and so on again in order to get the dates
when payments are due?

Excel 2000/XP, Win 2000/XP

Thank you very much

Aivars

adding changing number of days
 

Assume first date is in A1
in A2
=a1+if(mod(row(),2)=0,181,184))

Then drag fill down the column

Regards,
Tom Ogilvy


"Aivars" wrote in message
om...
Hello,
Bank calculates loan repayment due dates like this:
1 181 day from drawdawn day
2 184 days from previous payment day
3 181 days from previous payment day
4 184 days from previous payment day
5 181 days from previous payment day
and so on
...
How can I make formula or macro add to previous date one time 181
days, next time 184 days and so on again in order to get the dates
when payments are due?

Excel 2000/XP, Win 2000/XP

Thank you very much

Aivars