Recently we received this query:

I need a little bit of information from you about ms excel function.

 

I would like to know whether can I set a date as repayment due date

between two dates in excel.

 

Suppose if we extend finance to a person between 06th day and 15 day

of a month, can I set the due date as 11th day of next month thru

excel formula.

 

Likewise if the loan is sanctioned between 16th day and 25th day, Can

I set the due date as 21st date

 

In the same manner if the loan is sanctioned between 26th day and 05th

day, Can I set the due date as 02nd date.

 

To set 3 dates between three sets of dates, we require conditional function.

 

IF you don’t mind, could you please inform me by using which formula,

we may set the above.

Our solution is that by using the mix of functions being DATE, EDATE and EOMONTH it would be possible to achieve this.  To see how to use these functions you can watch the video clips on

http://www.auditexcel.co.za/DATE_DAY_MONTH_YEAR.html and

http://www.auditexcel.co.za/EOMONTH_EDATE.html