Date Increasing

[mok1995]

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
i will link the file, 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 ?

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[mok1995]

Thank you, it is uploaded

[tanasedn]

Hi,
I tried to resolve your problem without VBA.
First: I separate the column "Tasks.Schedule" in two columns with text to columns feature.
Second: I created a new column for the schedule date with the formula:

Please Login or Register  to view this content.

After that you can simply filter to find the upcoming schedule maintenance date

[mok1995]

Hi,
I tried to resolve your problem without VBA.
First: I separate the column "Tasks.Schedule" in two columns with text to columns feature.
Second: I created a new column for the schedule date with the formula:

Please Login or Register  to view this content.

After that you can simply filter to find the upcoming schedule maintenance date

I did not understand the first step
Also i have tasks to repeat every 11 months, the same method ?

[tanasedn]

If you don't know how to use "Text to columns" from Data tab, maybe the formulas are more useful.
I attached the file with those modifications. But there are some inconsistency in the periods in your worksheet. You have, in Task.Schedule column, periods like NM:4 and w8. It's difficult for anyone to handle this..

[mok1995]

I understand you, but the date was 2012, i need to reach 2021 and next years, i do not need the next day only
thank you

[tanasedn]

Hi,
On the column that I named "Next Date" in last attachment you can just filter for what year you need.
I have some question: the column Tasks.DateLastDone is always in the text format?
And the column Tasks.Schedulecan have records like M3 and M:3 ?
What are the entire list of time periods (like D, ND, W, NM) that you will have in that column?

[mok1995]

Hi,
On the column that I named "Next Date" last atachement you can just filter for what year you need.
I have some question: the column Tasks.DateLastDone is always in the text format?
And the column Tasks.Schedulecan have records like M3 and M:3 ?
What are the entire list of time periods (like D, ND, W, NM) that you will have in that column?

Yes it is in text format not date format and the task schedule did not defined but as you mention nm:3 means one every 3 months and so on

[tanasedn]

Yes it is in text format not date format and the task schedule did not defined but as you mention nm:3 means one every 3 months and so on

But I can find it in both formats? As NM3 and NM:3 (with and wihout ":")

[mok1995]

But I can find it in both formats? As NM3 and NM:3 (with and wihout ":")

I mean I want to do it as a loop by vba or not, these dates in 2012, i want them to be continuous for future