Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing cell if within 365 days? | Excel Discussion (Misc queries) | |||
how do i convert a number of days to years, months & days? | Excel Discussion (Misc queries) | |||
changing weekend days | Setting up and Configuration of Excel | |||
A number of days into weeks and days | Excel Worksheet Functions | |||
What is the formula for adding a number of days to an existing dat | Excel Worksheet Functions |