[Solved] Calculate End date with Start date, Training hours and Based on Working days

Originally Posted by kvsrinivasamurthy

Does UDF will do.

Hi Kvsrinivasamurthy, sorry I am quite a noob in excel and does not really know what you meant by UDF. What happened is that I just took over a portfolio from my predecessor and she used to do manual calculation for such training end dates and I find it unproductive. Therefore, I was thinking if a formula could solve it more faster, especially if there are alot of new sign-up trainees within a month.

Originally Posted by kvsrinivasamurthy

UDF means user defined function. We have to write code for function. It can be used like other functions.

I see. Thanks for educating and I learn something new to me today. Really appreciate your help on this. Will test it out and update here again.

Originally Posted by kvsrinivasamurthy

Here is the code for UDF of GetDate.
How to paste the code?
In Developer Tab click on Visual basic.
VB window opens.
Insert --> Module
Now copy and paste the code into VB window.
Close VB window.

GetData function is available in excel function list.
See the file.
Any clarifications welcome.

Please Login or Register  to view this content.

Hi Kvsrinivasamurthy, thank you very very much. It works like a charm.....!!! Really save me alot of time from manual calculation on a calendar. Now I have more time to do other more important stuffs.