New to all this, so i apologize in advance for my ignorance. I have a calendar that tracks people’s leave/TAD time based on dates. Currently I have the dates listed in series in a single column labled “date” on the LEAVE tab. Can i switch this to work with just a simple “start date” and end date” I am trying to reduce the overwhelming number of lines on the LEAVE tab.
my sheet: https://docs.google.com/spreadsheets/d/1ektARrWjd108GVnx5OLYtNqI9UB1V9KXLIiexw_0FgI/edit?usp=sharing
current formula: =if($B5 <> “”, iferror(vlookup(vlookup($B5&D$4,LEAVE!$A:$F,6,false),Lookups!$A:$B,2,false),””),””)
I have tried several things from google/youtube but i lack the knowledge required to implement them properly.
Shane Preston is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.