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 i...
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.
dmitriusjoleskevich Okay! and what am I looking at?