Swapnil
Member
Greetings !!!!!!
This is a recent problem I came across. I have two sheets here , One containing employee bill details ( along with desired Output ) named " Employee Billing Data". While the other have their travel details along with Geography in which they traveled named "Travel Data".
I need to find out how many of their travel days fall within a particular billing cycle , and need to populate the same in respective geographies.
attaching the file for ready reference. Looking forward to an Awsome solution from Awsome excel gurus.
This is a recent problem I came across. I have two sheets here , One containing employee bill details ( along with desired Output ) named " Employee Billing Data". While the other have their travel details along with Geography in which they traveled named "Travel Data".
I need to find out how many of their travel days fall within a particular billing cycle , and need to populate the same in respective geographies.
attaching the file for ready reference. Looking forward to an Awsome solution from Awsome excel gurus.