my invoices need to show a due date of the 10th of the following month
provided the current date is no later than the 27th.

an invoice going out on 6/26/2008 should show a due date of 7/10/2008.

working with dates in excel is new to me, any help would be welcome.