Mac Numbers formula question

Discussion in 'Mac Apps and Mac App Store' started by manxkipper, May 27, 2009.

  1. manxkipper macrumors newbie

    May 27, 2009
    I want to set up a cell that has a number in it. That number is to decrease by one every seven days is there a formula that I can use to do this automatically
  2. DSG macrumors regular

    Jul 11, 2008
    I don't use Numbers but in Excel, a suitable formula would be:

    =[Initial]-INT((TODAY()-DATE([Year], [Month], [Day]))/7)

    Where [Initial] is the starting value and [Year], [Month] and [Day] refer to the day on which you want the countdown to start. Hence, a cell that started at 100 and reduced by 1 every 7 days from today would be generated by:

    =100-INT((TODAY()-DATE(2009, 5, 27))/7)

    I assume Numbers has equivalent functions. INT() is the integer function - it returns the portion of the expression in the brackets that is a whole number and disregards the rest (i.e. the decimal value) - otherwise the initial number would decrease by 1/7 each day. TODAY() returns today's date and DATE() returns the date defined by the terms in the brackets.

    Hope that helps!
  3. manxkipper thread starter macrumors newbie

    May 27, 2009
    Yes it did thanks. Numbers did not let me do the INT of Today but by splitting the formula into two cells it worked. A bit messy but hey it works

    Thank you for your help
  4. Pmatth macrumors newbie

    Dec 26, 2011

    Hi Manxkipper

    I'm trying to do the same thing in numbers could you post a copy/sample of your formula?


Share This Page