I am doing planning for a maintenance schedule. I can easily calculate when maintenance on a machine should start, but I need to show the status of it every day. How to make the status of the activity for each day?
I am doing planning for a maintenance schedule. I can easily calculate when maintenance on a machine should start, but I need to show the status of it every day. How to make the status of the activity for each day?
Not sure how dynamic you need it to be. But here's starting point.
In E10: This is expanded by auto-array behavior
Formula:Please Login or Register to view this content.
In F10: Copy down to match array in column E.
Formula:Please Login or Register to view this content.
FYI - There was likely error in your workbook. I assumed that C16 should be 2/7/2024. Not 1/7/2024.
See attached sample.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks