Log In
Register
Home
March 5, 2017
Offline
I want to be able to populate/plot 'autopay' 'amounts' along the dates according to the 'frequency' which will be either weekly/fortnightly/monthly.
I would only need to input into columns C,D and E for all the columns from F to be populated with figures from column C
Thank you in advance.
I plan on placing the crucial data on a separate sheet but this helps me visually.
I also see an upcoming dilemma having income and expense in the same sheet unless I make expense figures 'negative'.
pls see the file attached
See Answer
VIP
Trusted Members
June 25, 2016
Offline
Hi mey
Give this a try.
Sunny
March 5, 2017
Offline
Hi, Would you be able to further help me?
I've tried to learn a few more functions in order to nest a frequency of 'same day every month'
I've looked at nesting an IF and DATE
but I don't know where to logically place it as it complicates simple values of 7 and 14.
Maybe easier to have a monthly section below weekly/fortnightly and manually enter the expenses in appropriate sections.
VIP
Trusted Members
June 25, 2016
Offline
Hi mey
I don't quite understand your question. Maybe you can attach some examples.
March 5, 2017
Offline
Please see the attached file
VIP
Trusted Members
June 25, 2016
Offline
From your original question you wanted weekly/forthnightly/monthly as the frequency and you also have a start date. Without using 7/14/31 how will you determine the date of the expenses? Maybe I misunderstood what you wanted.
From your post #5 you said "needs to be same day every month not just a number value like 7 and 14". Same day every month compared to what?
If the start date is 04/05/2017 then the next date will be 04/06/2017 etc (same day) ?
Can you give sample data (as many as you can) and their expected results (ignoring my formulas)? It will make it easier to understand.
March 5, 2017
Offline
Hi Sunny,
thanks for your promp reply
yes,if start date is 04/05/2017 then the next day is 04/06/2017 (same day).
VIP
Trusted Members
June 25, 2016
Offline
If you are using start date as the next day (same day/different month) you will need to be careful when the start day is 29, 30 or 31 as not all months have this day.
I have included 2 formulas (yellow and blue) for you to choose. The one in blue caters for these end-of-month date i.e. if start day is 28/02/2017 (end-of-month date) then the next day will be end of the following month (31/03/2017, 30/04/2017 etc). If it detect that the start day is an end of month date, it will ignore 28 as the same day.
Hope this helps.
Sunny
Answers Post
1 Guest(s)
