Forum Discussion
Formula is not working and is lengthy
Using below formula to count the leaves between the dates. But i do not know what is wrong with my formula that why its not making calculations whereas it is accurate. and i am also looking to sh...
TheOcean Oh my! What a formula. I don't even dare to start analysing it. Rather than revising the formula, I would like to suggest that you change the way you capture leave data. Use one table and then create whatever summary report you want/need from it. Sheet2 in the attached (your) sheet is just an example of what is possible, using a pivot table.