I have a sheet that contains leaves applied by employees.
This sheet has leaves applied for atleast last 4 months. (“mm/dd/yyyy”)
Ex: 1 employee has applied leave like from:1/15/2018 to:1/17/2018
And same employee has also applied from:2/4/2018 to: 2/4/2018
Now there’s another who has applied leaves as from:1/1/2018 to:4/31/2018
I want to apply filter or extract leaves applied only for certain month in all three examples.
I have wracked my brain. tried applying month filter…but got the error- January is not a column/feb is not a column…
Any help is greatly appreciated.