formula calculating date
 

I have the current date in cell A1 =TODAY(). In cell A2 I need the next
10th. So, if todays date is 12/13/07 I need A2 to return 1/10/08. If
today's date is 2/9/08 I need the date 2/10/08 returned in cell A2.

formula calculating date
 

What should happen when today *is* the 10th?

Try this:

=DATE(YEAR(A1),MONTH(A1)+(DAY(A1)10),10)

2/9/2008 will return 2/10/2008
2/10/2008 will return 2/10/2008
2/11/2008 will return 3/10/2008

--
Biff
Microsoft Excel MVP


"MelB" wrote in message
...
I have the current date in cell A1 =TODAY(). In cell A2 I need the next
10th. So, if todays date is 12/13/07 I need A2 to return 1/10/08. If
today's date is 2/9/08 I need the date 2/10/08 returned in cell A2.