Forum Discussion
Need help in finding number of days of emloyment in any given year
Hello,
In the attached file, columns C and D contain data on Dates of Joining and Dates of Leaving, respectively for various employees. Row 3 (Column E to N) show the various year ending periods (April to March).
I need help in calculating the number of days each employee was in services (in columns E to N) depending on their data in columns C and D, with logical checks - such as any employee joining after the year end should have 0 days of employment and any employee leaving before the beginning of the year to also have 0 days).
Quick assistance on this file will be most appreciated.
| DOJ | DOL | 31-Mar-25 | 31-Mar-26 | 31-Mar-27 | 31-Mar-28 | 31-Mar-29 | 31-Mar-30 | 31-Mar-31 | 31-Mar-32 | 31-Mar-33 | 31-Mar-34 | |
| Current | 30-Sep-24 | 31-Mar-34 | 182 | |||||||||
| Current | 31-Mar-24 | 31-Mar-33 | 365 | |||||||||
| Current | 31-Mar-24 | 31-Mar-32 | 365 | |||||||||
| Future | 1-Dec-25 | 31-Mar-31 | -245 | |||||||||
| Current | 31-Mar-24 | 31-Mar-30 | 365 | |||||||||
| Current | 31-Mar-24 | 31-Mar-31 | 365 | |||||||||
| Current | 31-Mar-24 | 31-Mar-29 | 365 | |||||||||
| Future | 1-Sep-26 | 31-Mar-32 | -519 | |||||||||
| Current | 31-Mar-24 | 31-Mar-29 | 365 | |||||||||
| Current | 31-Mar-24 | 31-Mar-29 | 365 | |||||||||
| Current | 31-Mar-24 | 31-Mar-31 | 365 | |||||||||
| Future | 1-Sep-26 | 31-Mar-32 | -519 | |||||||||
| Current | 31-Mar-24 | 31-Mar-27 | 365 | |||||||||
| Current | 31-Mar-24 | 31-Mar-29 | 365 | |||||||||
| Current | 31-Mar-24 | 31-Mar-31 | 365 | |||||||||
| Current | 31-Mar-24 | 31-Mar-33 | 365 | |||||||||
| Future | 1-Dec-25 | 31-Mar-31 | -245 | |||||||||
| Future | 1-Dec-25 | 31-Mar-31 | -245 | |||||||||
| Current | 31-Mar-24 | 31-Mar-31 | 365 | |||||||||
| Current | 31-Mar-24 | 31-Mar-31 | 365 |
nkurup Perhaps the attached file with a rather old-school solution might work for you.
