| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Trying to get the next date exactly 5 years ago..
I use the following function(s) in a list of dates (ascending, obviously) to
=VLOOKUP(DATE(YEAR(NOW())-5;MONTH(NOW());DAY(NOW()));$A:$A;1) This gives me either today, or the last occurance of the same day 5 years ago if today is not available. I know what causes this, but can anybody give me a not too complicated formula for getting the next one? Thanks a lot! Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| calculate no. of years between a date and today's date | Excel Worksheet Functions | |||
| calculate date differences in years and months | Excel Worksheet Functions | |||
| Calculat years married or age of someone on today's date | Excel Worksheet Functions | |||
| How do I set up a date cell to and 15 years in another cell? | Excel Worksheet Functions | |||
Threaded Mode
