Easy Excel Qu of the day

[Sir Tokyo Sexwale]

I have a lease payment schedule - payments are mid-month.

 

I don't want to type all of the dates, I want a simple formula so I type one & the formula does the rest. But the payments are mid-month, so EOMONTH won't work.

 

So - starting 14 Aug, I then want 14 Sept, 14 Oct etc.

 

14 Aug +30 or +31 isn't going to work. So what will?

[Candystore]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Bigal]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[charlie clown]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[John am Rhein]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Sir Tokyo Sexwale]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here