Hi All,

I've a vb3 application. I need to modify the application to do the below.

For example,
date1, date2, date3 are the calculation dates. If my transaction has a date say trdate, then if the trdate is equal to date1, then add the amount, if it's equal to date2, then add the amount with that on date2 and so on.

My problem is this date1, date2, date3 can only be valid business dates, i.e. no sat,sun or holidays and if the trdate is equal to date1 - add the amount with that on date1, if it's greater than date1 and lesser than date2 and if the difference between trdate and date2 is just one day. i.e. one holiday after date1, then add the amount with date2, if it's greater than 1 i.e. 2 or more holidays then add with that in date3.

Hope I've not confused.. Any suggestions to find the date difference is much appreciated...

Thanks a lot.