Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Weeknum & Year
Hi I asked this question once before about a year ago, but I can't remember what the solution was. I want to be able to display the week number and the year together, as some of my dates are now beginning to run in 2006. Can someone advise how I do this? Thanks Anita |
#2
|
|||
|
|||
=WEEKNUM(A15)&"/"&YEAR(A15) where your date is in A15
-- Ian -- "AnitaML" wrote in message ... Hi I asked this question once before about a year ago, but I can't remember what the solution was. I want to be able to display the week number and the year together, as some of my dates are now beginning to run in 2006. Can someone advise how I do this? Thanks Anita |
#3
|
|||
|
|||
Thanks very much Ian - that did the job perfectly.
Anita "Ian" wrote: =WEEKNUM(A15)&"/"&YEAR(A15) where your date is in A15 -- Ian -- "AnitaML" wrote in message ... Hi I asked this question once before about a year ago, but I can't remember what the solution was. I want to be able to display the week number and the year together, as some of my dates are now beginning to run in 2006. Can someone advise how I do this? Thanks Anita |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
bar graph showing year of birth and death of several people | Charts and Charting in Excel | |||
Auto Year scale | Charts and Charting in Excel | |||
How to compare current year to prior year in bar chart? | Charts and Charting in Excel | |||
Need totals of values that fall within a given year | Excel Worksheet Functions | |||
Weeknum Year by Year Compare | Charts and Charting in Excel |