i am having trouble with the following scenario. i am inputting escalation dates into a contract database and want to make an adjacentcell show the upcoming escalation date. for example, in a 5 year contract starting 1 May 2009 if the escalation date annually is 1 July, and say today is the 20 June 2011, the upcoming escalation date would show 1 July 2011, then from the second of July, it will show the next date - 1 July 2012.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
if formula question about dates
- Thread starter ajm
- Start date
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
Try this...
Contract dates starting in A5
List of escalation dates, named range
In B5 put this and fill down...
=INDEX(EscalationDates,MATCH(A5,EscalationDates,1)+1,1)
Denis
Contract dates starting in A5
List of escalation dates, named range
In B5 put this and fill down...
=INDEX(EscalationDates,MATCH(A5,EscalationDates,1)+1,1)
Denis
Upvote
0
hey Denis, its been a while. hope you are well. i don't understand how your solution will provide the answer that I am after. won't your solution be looking for a match between the start date and the escalation date?
Upvote
0
Similar threads
- Question
