| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a formula calculating all cells after a certain date | Excel Worksheet Functions | |||
| How do I set up a formula for calculating an expiration date? | Excel Worksheet Functions | |||
| FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL DATE | Excel Discussion (Misc queries) | |||
| Formula for Calculating a Floating Date | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Linear Mode
