What if it **is** after the 27th... what should be shown then? You will
probably answer this with your answer to the previous question, but in case
not<g, what if the current date is before the 10th of the current month?

Rick


"slow but sure" <slow but wrote in message
...
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.