1

My spreadsheet contains data divided into weeks in a year and I would like to combine the following two pieces of information in one cell:

  • =ISOWEEKNUM(TODAY())
  • Calendar week

'Calendar week' being the name of the whole column is just a text that I would like to maintain and the week number would be a help to see what week it is (either before or after the 'Calendar week').

Improve this question
1

  • shorter:

    =ISOWEEKNUM(TODAY())&"Calendar week"

  • or with space perhaps (?):

    =ISOWEEKNUM(TODAY())&" Calendar week"

Improve this answer
1
  • 1
    Thanks for better formula! Instead of a space I have used "fill range" twice so it's nicer to look at. – Marek Marhoul Mar 20 '19 at 16:53
0

Well, I found one way to do that. Of course, if there is any simpler/faster/better way, do let me know

=CONCAT(ISOWEEKNUM(TODAY()); "Calendar week")
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.