asign the next 10th as the due date.

[slow but sure]

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.

 

[Rick Rothstein \(MVP - VB\)]

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

 

[FSt1]

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

 

[Ron Rosenfeld]

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

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