Mar 09 2022 12:30 AM - edited Mar 09 2022 02:10 AM
Peace..
Let say we have a report of annual leave days of employees (2021) . The report shows the period(start and end date) and total days, ok? for example :
the row: (name :Mark) (period :Start of leave: 28-3-2021 end of leave: 3-4-2021) . total days: ( 6 days) .. this is the current available report, ok?
What I want is dividing this leave of employee as month in excel.
I mean separating leave as total days for every single month in single row:
for example(it is one connected leave by one request from employee):
Row1: Mark , (start date: 28-3-2021 - end date : 30-3-21)
Row2:Mark, (start date: 1-4-2021 - end date 3-4-2021)
so, before dividing, it was one row.
And so on as for leave with total days :70, report should gives me 3 rows.
How to resolve this problem so fast? in few minutes (hundreds of rows).
Thanks.
Mar 09 2022 01:42 AM