Home > Mobile >  Formula which show the Leaves data into months view
Formula which show the Leaves data into months view

Time:01-12

I have created a attendance module in the Google Sheets where i have one problem to present the data from one sheet to another. Currnetly i am using the INDEX MATCH function which is not working accurately.

I want to populate the Data according to each date and whenever the months changes then data should be change accordinly.

I have multiple employees which Leaves are of different types i want them to populate for the whole month.

    =ArrayFormula(XLOOKUP(1,(D$7>=Leaves!$D:$D)*($AJ$6<=Leaves!$E:$E)*(Leaves!$B:$B=$C8),Leaves!$I:$I,""
))

I have attached a google sheets which may explain better what i want to achieve. Your help will be much appreciated.

enter image description here

  • Related