Hi,
With your start date in B1 and your rate in C1, then you could use this in D1
=IF(C1>0.1,EDATE(B1,24),EDATE(B1,36))
and this in E1
=D1-90
Format cells to DATE, you will also need the Analysis Tool Pak add-in to use EDATE function
http://www.cpearson.com/excel/ATP.htm
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thank you so much. I took advantage of what you wrote here and enhanced the idea when I applied it. I've gone to the links you posted and am grateful for you taking time to offer the link.
Thanks a million.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks