Please excuse if this is not that clear. I am having a day where I cant articulate my thoughts very clearly.
I have a workbook that we are going to use in Teams - so I cannot use VBA/macros.
It is to keep track of servicing of equipment, and so I am trying to have it return a specific option from a list based on where it is sitting date wise.
For example....If it is older than the current month it is = Overdue.
If it is within the current month and the next month = Due
Falling further than the next month will = BLANK, or they will have a status from the list i.e SERVICED for those that are in service.
I also need to be able to use the vlookup list to mark them as REMOVED when we take them away.
BUT
The service due date is generated from formula : =EDATE(K26, 6)
as they are due every 6 months.
The Vlookup and the date are on a separate sheet.
This should be really simple but I am running into a mental brick wall with this today. I did find a formula but it did not work with the =edate formula.
I have a workbook that we are going to use in Teams - so I cannot use VBA/macros.
It is to keep track of servicing of equipment, and so I am trying to have it return a specific option from a list based on where it is sitting date wise.
For example....If it is older than the current month it is = Overdue.
If it is within the current month and the next month = Due
Falling further than the next month will = BLANK, or they will have a status from the list i.e SERVICED for those that are in service.
I also need to be able to use the vlookup list to mark them as REMOVED when we take them away.
BUT
The service due date is generated from formula : =EDATE(K26, 6)
as they are due every 6 months.
The Vlookup and the date are on a separate sheet.
This should be really simple but I am running into a mental brick wall with this today. I did find a formula but it did not work with the =edate formula.