Please Help! Need a formula(s) that derive a ratio from calendar dates

Hello Excel Forum!

I could use some help figuring out a series of formulas. I'm looking for a formula that can take a date range say 11jan2013 to 11apr2013 count the days in between and then display it as a ratio based on 'today's date'. So keeping with the above example 11jan2013 to 11apr2013 and if today's date was 11jul2013 the ratio would be 1:1 since there are 3 months between the first two dates and then it is three months from 11apr2013 to 11jul2013. And if today was 11oct2013 the ratio would be 1:2 since it would be 6 months after a 3 month date range. It doesn't have to be expressed in a ratio, it could be in a percentage. Thanks everyone!

You sir are the man. Much appreciated!

Hey,

Thanks a bunch. I tried that but I 'm not sure why it didn't work. I used =C2+(F2*2) where c2 is the return date and f2 was the difference between the start date and end date and it is working fine. Thanks!