formula calculating date

G

Guest

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.
 
T

T. Valko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing Dates in 4 Columns - Nested Formulas? 2
macro help 1
Calculating time between mulitple dates 4
Date shows as a number 1
TODAY formula 2
Creating a Formula with Dates 1
Report data from cell if dates match 2
Seniority Years Formula needed 5

Top