New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Week number in text format

Macros, VBA, Excel Automation, etc.

Week number in text format

Postby bejoyhenry » Sat Feb 06, 2016 2:51 am

Hi

I want to display the week numbers in text.
For example =WEEKNUM(A23,1) where A23 is 01-02-2016 return type is 05 but i want it to display as Week 05

Please help me

Regards
Bejoy
  • 0

bejoyhenry
Rookie
 
Posts: 1
Joined: Feb 6, 2016
Reputation: 0
Excel Version: 2013

Re: Week number in text format

Postby pecoflyer » Sat Feb 06, 2016 3:02 am

Hi and welcome

Try ="Week "&text(WEEKNUM(A23,1),"00")
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 53 guests