Date Function (Logical Approach)

Hi,

I have attached the sample file to understand the solution i am looking for.

If you notice i have added 3 tables data .. also i had created a sample solution calc for emp1 and project1 ... i need to calculation the ration between the months based on the working days and allocate the efforts accordingly. Please advice

Hi,

I tried multiple ways, but its making more complicated and data reference ... should we approach the VBA coding? .. but i want this to be formula driven :-)

Hi,

It took some for me .. but i was able to come-up with logic and its working perfectly ... ..

Formula:

Please Login or Register  to view this content.