MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Create a Numbers Project That “autoupdates” the # Of Days?

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

Comments: 2 Responses to “How Do I Create a Numbers Project That “autoupdates” the # Of Days?”

    6 months ago

    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.

    JerryP
    6 months ago

    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.

Comments Closed.