What formula do i use to automatically change the week to working a week in advance?

[Seamus1791]

Hi,

I am trying to put in a formula to auto update my week number so my spreadsheet is one week in advance, I know to make it this week I use this formula: =CONCATENATE("WEEK:",WEEKNUM(TODAY()))

My question is how do I take it from this week showing "WEEK 35" to working in advance so it would say "WEEK 36"

Cheers

 

[Oeldere]

Did you tried the option below?

=CONCATENATE("WEEK:",WEEKNUM(TODAY())+1)

 

[wesimmo]

You just need to increment the week, so put a "+1" after the bit where you derive the current week.

=CONCATENATE("WEEK:",WEEKNUM(TODAY())+1)

 

[hippiehacker]

hi,

i am trying to put in a formula to auto update my week number so my spreadsheet is one week in advance, i know to make it this week i use this formula: =concatenate("week:",weeknum(today()))

my question is how do i take it from this week showing "week 35" to working in advance so it would say "week 36"

cheers

=weeknum(today())+1

 

[Seamus1791]

No, I tried a few variations but am not very strong on Excel.

Thank you for your help.

 

[Oeldere]

Did you tried my solution?

If so, what is the result in your file?

 

[Seamus1791]

worked as planned, file now says "WEEK: 35" so 1 week in advance.

Thanks

 

[Oeldere]

Re: What formula do i use to automatically change the week to working a week in advance? (Solved)

Thanks for the reply.

Glad I could help.