Looking for a formula to return number of months left from TODAY to a particular future date (09/30/2009). The value is then going to be multiplied by value in neghboring cell (e.g. B2) to produce a total amount to be charged from todays date till 09/30/2009.
Trick is that when I use this formula tomorrow, it should not change the value of this total amount - it should stay same as it was today.
ideas? Thanks
Bookmarks