In the attached you can see that cell E12 counts the day until the next service of a Generator. In Row 4 the status of the set is manual entered; On = On (Cell BZ120, GLS= standby (Cell BZ11 counts the days in standby). There is a period of 21 days between services.
The issue i have is that the count of stand by days needs to begin at the start of the month previous to the current however a service could land at any time in the month. This is affecting the 'Days to next Service' Cell E12 as the Count is including standby day before the service.
In this example it should read 11 days however it is counting the 3 days standby from before the service.
Is there a way of finding the service in Row 10 (Cell AD11) and then counting how many standby days there have been between then and today.
Bookmarks