Hi -
I am looking for a formula that will reference a cell with today's date and then find the next date in a column with approximately 40 quarterly or semi-annual dates.
Thanks for your help.
Hi -
I am looking for a formula that will reference a cell with today's date and then find the next date in a column with approximately 40 quarterly or semi-annual dates.
Thanks for your help.
Hi, your dates in A2:A100
=index(a2:a100,match(today(),a3:a101,1))
or
=index(a2:a100,match(today(),a2:a100,1)+1)
Regards
Last edited by canapone; 09-26-2011 at 01:50 AM. Reason: 0 to 1
Thanks for this. I tried this formula and got the #n/a error. I think the issue is that today's date is not in the range of dates - what I am looking for is the next date after today's date in the column. Example - if today's date is Sept 26, 2011 and the array has quarterly dates from Sept 30, 2010 to Sept 30, 2020, I am looking for a formula that would pull the next date in the range after today`s date (Sept 30, 2011).
Thanks
Hi,
waiting for better solutions
=IF(ISNA(INDEX(A2:A20,MATCH(C2,A2:A20,0))),INDEX(A2:A20,MATCH(C2,A2:A20,1)+1),INDEX(A2:A20,MATCH(C2,A2:A20,0))
Regards
That works great, thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks