If current date is less than a recurring monthly payment date

[coasterman]

Hi,

II'm trying to set up a home budget tracker but am having problem with the logic around reoccurring monthly direct debits. In plain English here's what I'm trying to achieve.

if current day of month is less than day of month direct debit then next direct debit date = current month + direct debit day of month else next direct debit date = Next month + the direct debit day of month.

For example if

Mortgage payment goes out on the 19th of each month and today is the 7th

If 7 < 19 then next mortgage payment = 1st date of current month(01/09/2013) + 19 else 1st Date of Next Month (01/10/2013)+ 19

I think the problem I am having is retrieving the 1st day of the month e.g 1st Sept rather than just the month expressed as a numeral?

thaks

[oeldere]

You get better help on your question if you follow the advice in the link below.

http://www.excelforum.com/the-water-...-question.html

[Fotis1991]

If you have Excel 2003 and you have the EOMONTH function on your computer OR you use Excel>2003, give a try to this.

=IF(DAY(TODAY())<19,EOMONTH(TODAY(),-1)+1,EOMONTH(TODAY(),0)

[Fotis1991]

I see that you marked your thread as solved. That's great. This means that my suggestion works for you.

I just want to say that The feedback is always appreciated from the people that offered you the solution that you was looking for.

Thank you.

[coasterman]

I did also quick reply thanking you for your help and confirmed by changing the Windows system date your formula worked a treat. I must have done something wrong as it's missing from the thread. Anyway my thanks to again.

[Fotis1991]

You are welcome and thanks for the understanding.