How do I crate a function for week of year + year in same cell.

P

patty ann

I'm not real experienced in entering functions and I want to pull into a cell
the week of the year and year. The data is coming from a cell like 1/9/2008.
I know how to create the week of year but I do not know how to add the year
and it to show up as 22008. Week 2 of 2008
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort by Year and Week 1
Sort by week and year 3
Same Date a year ago 4
Default Other Than the Current Year 3
Calculating quarters of a year. 4
Year + week => first date of week 9
Tie a Calendar week to a Scoped Projected Week 3
Partial Year Adjustments (Mod Function) 1

Top