How can I change a date to a week number?

[sherswan]

I have been given a project for an internship that asked me to design and enter all the info for the workers for 2013 and the hours, day, week, month, etc. that they worked. I have never really worked with Excel and I can't figure out how to change the long date into the week # (1-52). I would appreciate any help offered. If I am not in the right place, please feel free to tell me. Sherri

 

[pbaldy]

I'm not strong in Excel, but does the WeekNum() function do what you want?

 

[sherswan]

I don't find that under format cells, is there somewhere else I could look?

 

[pbaldy]

It's not a format, it's a function, so if you type

=weeknum

in a cell you should see it come up as an option. You can look in help at it as well.

 

[sherswan]

You're awesome! I wish I would have came here first instead of spending so much time trying to do it myself. Thank you!

 

[pbaldy]

Happy to help, and welcome to AWF!

 

[sherswan]

One more question, can I also change the long date to a different cell displayed as only the month (January, - December)?

 

[pbaldy]

For the number 1-12 the Month() function. For the month spelled out check out the Text function:

=TEXT(A1,"mmmm")

 

[sherswan]

OK, I have the numbers 1-12, not I will try to get the text. Thanks again.

 

[sherswan]

It worked perfect! Now on to other things, like designing it.

 

[pbaldy]

Excellent! You're pushing my limited Excel knowledge here.