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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I crate a function for week of year + year in same cell. (https://www.excelbanter.com/excel-worksheet-functions/180234-how-do-i-crate-function-week-year-year-same-cell.html)

patty ann

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

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

Mike H

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

With a date in A1 try this

=WEEKNUM(A1)&" "&YEAR(A1)

Mike

"patty ann" wrote:

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

All times are GMT +1. The time now is 08:10 AM.