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
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
Return to Macros and VBA Questions
Users browsing this forum: No registered users and 33 guests