Forum Discussion
BerlyLinkin
Oct 01, 2023Copper Contributor
How to show current remaining working days according to roster
I have roster that shows 3 Employees complete month shift. What formula will show the working days left as the days get over. I mean the working days left should automatically remove the Offs based ...
SanthoshKunder
Oct 02, 2023Iron Contributor
BerlyLinkinI'm not entirely sure if I've grasped the question correctly!.
=1+(Enddate-StartDate)-COUNTIF(C4:AG4,"O")