| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Return a date 6 months from a date in another cell
I'd like to return a date 6 months from the date in cell m16. So if m16 =
1/21/04 I'd like it to return 7/21/04 in m17. Then in m18 I'd like to count the number of days between Todays date and the result of m17. Thanks for any help. |
|
#2
|
|||
|
|||
|
on cell m17 type
==DATE(YEAR(m16),MONTH(m16)+6,DAY(m16)) and on cell m18 type =m17-today() "Qaspec" wrote in message ... I'd like to return a date 6 months from the date in cell m16. So if m16 = 1/21/04 I'd like it to return 7/21/04 in m17. Then in m18 I'd like to count the number of days between Todays date and the result of m17. Thanks for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
| Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions | |||
Linear Mode
