This is what I have for data
A B C
02/02/2007 10/09/2013
03/02/2010 21/12/2015
04/05/2013
I want cell C to look at A and B dates in the same row and pick the one that has a year of 2013. Then take that cell and calulate the (yearfrac(start_date),end_date,basis) function using start_date = cell with date of 2013 and end date = Dec 31, 2013
Can anyone help?
Bookmarks