Forum Discussion
Tracker for workers' promotion criteria
Hello, all.
I'm currently in the process of trying to make an all-encompassing tracker for myself and those I'm responsible for. I'm almost at maybe 70-80% solution, but now I am trying to see if there are ways to make it even more efficient. Which leads into my question/problem:
I'm trying to see, if there is a way for me to auto-populate preset formulas (in this instance, "=DATE(YEAR(C4),MONTH(C4)+# of months needed for position ,DAY(C4))") based on position, instead of me having to manually input them in.
dmitriusjoleskevich I guess you can use the EDATE function. For instance, =EDATE(C4,24) will add 24 months to the date in C4.
And if you have the number of months, let's say in C5, you can use =EDATE(C4,C5)
- I can prolly use that to clean up my tracker, but the problem lies in that I'd still end up having to manually put everyone's date on their based on different positions.
dmitriusjoleskevich Somebody needs to put the dates in sometime. Or do you have the dates for all staff and number of months for each position in a table somewhere else already?. Perhaps I'm just misunderstanding the meaning of "auto-populate preset formulas". And maybe you can upload or share a file (Onedrive, Dropbox etc.). That would make it easier to understand.
