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 Okay! and what am I looking at?
Essentially the only thing that matters is the rank DOR, BASD, TIS and TIG. So essentially what I'm trying to do is have formulas that feed into each other so i know the dates of how long a person has been in the organization (BASD), how long they have had the position (DOR). based on position (Rank), I'd like formula that I made (=DATE(YEAR(C4),MONTH(C4)+#,DAY(C4)) that feed into the last two acronyms (TIS based on BASD and TIG based on DOR) so I can know how long until they meet the time requirements for promotion.
dmitriusjoleskevich But where does the "#" come from? I presume that this is a number for each acronym (which, by the way, mean nothing to me).
A file, or a screenshot that includes column/row headers and a formula how you use it now would be helpful.
- # is the number of months you add based on rank. I don't know how to imbed a file.
dmitriusjoleskevich Perhaps the attached file demonstrates what I was thinking of.