I have a worksheet that I enter paycheck data on. The date of each check is
automatically computed. Checks is on the 15th and 30th of each month. After
setting the first pay date as 1/15/09, the remainder of the dates are
computed using the following formula (which works fine):


=IF(DAY(A42)=15,MIN(DATE(YEAR(A42),MONTH(A42),30), DATE(YEAR(A42),MONTH(A42)+1,0)),DATE(YEAR(A42),MON TH(A42)+1,15))

....where A42 = 1/15/09.

The problem I have is if the 15th or 30th falls on a weekend, then the
actual date needs to be backed up to Friday's date. Can someone show me how
to accomplish that?

Thanks,
Les