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.

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.

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.

With the invoice-going-out date in A1, maybe something like this would
work:
=EOMONTH(A1,--(DAY(A1)27))+10

hi
what happens if the current date is after the 27th?
using your example of 6/26/08, a formula could work...
=DATE(YEAR(D2),MONTH(D2)+1,10)
however, we need to work in the question above for a more complete solution.

Regards
FSt1

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

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