Auto Date Calculation Based on the given Input

[karthick87]

Hello All,

I use a excel file as Personal Loan Calculator and I just input the values in these cells (C3 to C8) and the excel sheet will get filled with rest of the calculated values. I just wanted to add a "Due Date" field to the excel sheet and it should get auto populated based upon the Sanction Date.. For now I have added the "Due Date" filed manually to make others understand easily. Could some one help me to populate that field automatically based upon the Sanction Date?

 

[Monty]

Hello Karthick.

New excel 2013 has great templates which is inbuilt.. you can make make use of it..Here is the screenshot.

 

[karthick87]

Thank you Monty. I have already looked into that. The one i have attached earlier is also a template but i have modified a little bit and now i wanted to add the date too in that..

It would be great, if some one could help.

 

[karthick87]

I have verified couple of other templates too to see how they have configured the date. However i was not able to get it done. Any help would be appreciated!

 

[bosco_yip]

I have verified couple of other templates too to see how they have configured the date. However i was not able to get it done. Any help would be appreciated!

1] In A12, formula copy down :

=IF(ROWS($1:1)<=C$4*C$5,EDATE(C$8,ROWS($1:1)),"")

2] Other formulae have made a bit adjusting in accordingly to remove 0.

Regards
Bosco

 

[karthick87]

Thank you @bosco_yip it helped