Populate cell with 15th of following month, or next week day

[vlc1982]

I'm trying to populate a cell with a date (15th day of the following month), but if that day is a Saturday or Sunday, I want it to return the next business day instead. I want the dates to remain static. I currently am able to get the cell to populate with the 15th of the following month by referencing another cell, but I don't know how to incorporate the weekend issue. Here is what I'm using to populate the 15th of the following month:

A1 = 5/1/14

Formula in B1: =DATE(YEAR(A1),MONTH(A1)+1,15)
Returns: 6/15/14

Problem: 6/15/14 is a Sunday, so I want the cell to return 6/16/14 (Monday), which is the next business day.

Any help would be appreciated.
Thanks!
Vanessa

[ChemistB]

Try this

=WORKDAY(DATE(YEAR(A1)-1,MONTH(A1)+1,15)-1,1)

[Kaper]

try:
=WORKDAY(DATE(YEAR(A1),MONTH(A1)+1,14),1)
it will take 14th and find next working day so if 15 is sat or sun - just next monday.

moreover - you could use optional third parameter to this function to exclude not only weekends but also bank holidays.

[vlc1982]

That worked...thank you!!!