Dear Members i need help with formula using Dates, where i need look up if these dates fall between another two date,
Leave Start Date - 1/19/2020 (Column B2)
Leave End Date - 2/01/2020 (Column B3)
I have two more columns where sate provides disability payment.
State Disability Benefit Start date - 1/20/2020 (Column E2)
State Disability Benefit End date - 1/20/2020 (Column E3)
State provides Disability benefit of $1000 per week. (Column H2)
I would like to find out the total benefit amount that employee receives through State, if Leave start date and Leave end date falls between State Disability Benefit start date and End Date then i need to know the total number of days where employee is receiving state benefits and total amount. So that i can deduct this amount pay remaining salary
Please help me
Thank you
Harsha
Bookmarks