Hello all
I have an excel sheet containing information for many machines that needs maintenance, each machine has a starting date of maintenance and the maintenance will be done repetitively in a specific frequency ( some are daily, weekly, monthly, semi annual or annual and many frequencies), i need to put the date of today or tomorrow or any coming date to see what are the machines that need maintenance at that date and the information of each machine
the task schedule is the frequency (NM:1 is monthly....) the task last date done is the reference date of each machine
how can i do it ?
the dates are in 2012, and i need to show my current date with the tasks meet in today date in 2021
I have an excel sheet containing information for many machines that needs maintenance, each machine has a starting date of maintenance and the maintenance will be done repetitively in a specific frequency ( some are daily, weekly, monthly, semi annual or annual and many frequencies), i need to put the date of today or tomorrow or any coming date to see what are the machines that need maintenance at that date and the information of each machine
the task schedule is the frequency (NM:1 is monthly....) the task last date done is the reference date of each machine
how can i do it ?
the dates are in 2012, and i need to show my current date with the tasks meet in today date in 2021