I need a formula that can calculate this for period ending every month
I started on rehire dashboard but I am missing the part to exclude the N/A
eg. For stats eff: March 31, 2018
I sort Col E (Contract End Date) for end dates greater than March 31, 2018 and dates N/A
then sort by col D (Rehire Date) for rehire dates earlier than March 31, 2018 (exclude N/A)
Then sort by LOB (Line of Business)
Appreciate any help
I attach a spreadsheet
Bookmarks