May 22 2022 10:53 PM
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.
May 22 2022 11:00 PM
@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)
May 22 2022 11:03 PM
May 22 2022 11:11 PM
@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.
May 22 2022 11:42 PM
@dmitriusjoleskevich Okay! and what am I looking at?
May 22 2022 11:49 PM
May 22 2022 11:57 PM
@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.
May 23 2022 12:01 AM
May 23 2022 12:06 AM
@dmitriusjoleskevich You can share a file via OneDrive or perhaps Dropbox.
May 23 2022 12:30 AM
@dmitriusjoleskevich Perhaps the attached file demonstrates what I was thinking of.