I want to create a Numbers file that has two columns of cells. The first column, “column one” will have a cell for each individual in our organization. When I create the second column, it will accurately reflect the number of days each individual in column one has been a member of the organization. That’s the easy part. Here’s the hard part. How do I make the second column “autoupdate” the number of days each individual in column one has been a member in our organization?
I don’t know if this important, but I will not have the actual date the individuals in column one joined up. I will only have the current number of days. I can work backwards and figure out the date if need be, but the Numbers file will contain well over 100 individuals.
As an alternative to “autoupdating”, I don’t mind typing in the current date ONCE if doing so will update column two of all 100+ individuals.
TIA!
JP
MBP 2015, MacOS 10.13.2, Numbers 5.3
—–
JerryP
How about this. Column A is the name. Column B is the starting number of days, like 57. Column C is the date when you entered the number of Column B, like 1/1/2019. Then Column D is B plus the DUR2DAYS of NOW() minus column C. So as the days go by, the value in column D increases by one.
You can hide columns B and C unless you are entering in new names/counts/dates.
Thanks! I didn't know that DUR2DAYS of NOW function. I ended up creating a temp Numbers file that converted all the days to a calendar date. I then copied and pasted all the dates to a column in the permanent document. I discovered that I had to enable "preserve row" in the variables contained within the dates otherwise it would just paste the date that is to be changed that affects the days. Finally, I created, copied, then pasted a formula changing all dates to days using a single input.