Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert a date to a week of the year? | Excel Discussion (Misc queries) | |||
Sort by week and year | Excel Worksheet Functions | |||
Sort by Year and Week | Excel Worksheet Functions | |||
Week of the Year | Excel Discussion (Misc queries) | |||
first week of year - according to european standard | Excel Worksheet Functions |