On Sun, 15 Jun 2008 17:39:00 -0700, slow but sure <slow but
wrote:

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.


Excel stores dates as serial numbers with 1 = 1/1/1900

Assuming also that an invoice dated 6/28/2008 should have a due date of
8/10/2008, try:

=DATE(YEAR(A1),MONTH(A1)+1+(DAY(A1)27),10)
--ron