Viewing 10 posts - 1 through 10 (of 10 total)
  • Excel help – Weekly count down
  • beamers
    Full Member

    Afternoon all, I’m after a bit of Excel help.

    I want to auto calculate the number of weeks remaining of the financial year so that I can use that number in another formula. The number of weeks remaining will automatically reduce as the year ticks by, which in turn will be used by another formula

    Anyone have any ideas?

    Many thanks in advance.

    TheFlyingOx
    Full Member

    =53-WEEKNUM(TODAY())

    works for Jan-Dec

    When does your financial year start?

    joshvegas
    Free Member

    Set two cells to date format.

    Type end of year in one

    Type =now() in tuther

    Third cell =cell1-cell2 then you need to decimal ise it and mind mind has gone blank.

    Fresh Goods Friday 696: The Middling Edition

    Fresh Goods Friday 696: The Middlin...
    Latest Singletrack Videos
    mogrim
    Full Member

    = (<whenever your financial year date is> – today() ) / 7

    Or Now() or whatever it is in English, my Excel is in Spanish 🙂

    joshvegas
    Free Member

    Divide by 7 as above

    slackboy
    Full Member

    something like this

    =ROUND((C2-TODAY())/7, 0)

    where C2 is the financial year end

    ROUND rounds the week up to the nearest integer.

    beamers
    Full Member

    Cheers all. I’ll have a play about with the formulas above.

    joshvegas
    Free Member

    Today() would work netter than now()

    Forgot that

    mogrim
    Full Member

    slackboy has the right answer (an improved version of mine) – although ROUND doesn’t round up always, it depends on the decimal.

    http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/whats-the-difference-between-round-ceiling-and/97d94607-69d5-4d35-b030-2f1942a51c6b

    slackboy
    Full Member

    slackboy has the right answer (an improved version of mine) – although ROUND doesn’t round up always, it depends on the decimal.

    yup, probably better to use ROUNDUP or ROUNDDOWN depending on preference.

Viewing 10 posts - 1 through 10 (of 10 total)

The topic ‘Excel help – Weekly count down’ is closed to new replies.