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.
=53-WEEKNUM(TODAY())
works for Jan-Dec
When does your financial year start?
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.
= (<whenever your financial year date is> - today() ) / 7
Or Now() or whatever it is in English, my Excel is in Spanish 🙂
Divide by 7 as above
something like this
=ROUND((C2-TODAY())/7, 0)
where C2 is the financial year end
ROUND rounds the week up to the nearest integer.
Cheers all. I'll have a play about with the formulas above.
Today() would work netter than now()
Forgot that
slackboy has the right answer (an improved version of mine) - although ROUND doesn't round [i]up[/i] always, it depends on the decimal.
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.