Dates

[LS Flowers]

Setting up a credit card worksheet register.
Column/Cell A-1=Due Date
Column/Cell B-1=Transaction Date
Payment due date is always on the 15th of each month, therefore if transaction date is May 14, 2012, Due Date will be May 15, 2012.
If Transaction Date falls on May 16, 2012, Due Date will be June 15, 2012.
I need a formula for Column/Cell A-1 that can read the date in Column/Cell B-1 and automatically relay the appropriate Due Date.
Thank you for your help

[Alexander_Golinsky]

=if(day(b2)>=15,date(year(b2),month(b2)+1,15),date(year(b2),month(b2),15))

[daddylonglegs]

What should the due date be if the payment date is 15th? is it the same date or the next month? For the former try

=DATE(YEAR(B1-15),MONTH(B1-15)+1,15)

If it should be next month then change the -15s to -16s

[LS Flowers]

Thank you Alexander_Golinsky & daddylonglegs for your reply.
Both replies worked well so now I must decide which to use.
Thanks again

[Alexander_Golinsky]

For sure, the 2nd one! i believe the most simple solution is the most beautiful one.

[LS Flowers]

I agree, but in this case, even tho I had not mentioned it in my query, I am able to use your solution with an "IF" included at the first in order to copy & paste down column A and keep the lower cells from being populated if Col B has no entry.
I'm sure daddylonglegs solution can be adjusted to handle this but I'm not seeing how to do it.
Thanks again for your help and have a great weekend.