Do we have a Formula to get the week from the date? :)

[pedie]

Suppose in cell 1 i have a date 9/8/2010, can the formula show me whether it is in week1, 2,3,4 respectively?

Thanks for helping!
Pedie

I have =WEEKNUM(H45,2) which return week number for whole year...But I am looking for like week1 of sept for instance. thanks again!

 

[hiker95]

pedie,

Excel Workbook
	A	B
1	9/8/2010	37
Sheet1

 

[hiker95]

pedie,

See Excel Help for examples.

 

[Matty]

But I am looking for like week1 of sept for instance. thanks again!

Hi,

September 2010 started on a Wednesday. So does week 1 start there or do you want to use a different logic? And if so, what is it?

Matty

 

[meldoc]

Hi Pedie

See the link.

http://www.mrexcel.com/forum/showthread.php?t=124863&highlight=weeknumber+month

 

[pedie]

Matty and everyone, thanks for helping!
I have a formula below...which is not accurate can can't be used without editing it for each month.
Suppose I have date 13 sept in cell a1, I want the formula in b2 to gimme week 3, or just number 3 for me to manually format it
So basically I am looking for week number of the month and not year!

Thanks again

=IF(DAY(H41)<8,1,IF(DAY(H41)<15,2,IF(DAY(H41)<22,3,IF(DAY(H41)<29,4,5))))

 

[barry houdini]

assuming you want it to work like WEEKNUM but within a month, i.e. 1st of the month is always week 1, changes to week 2 on the first Monday after that.

=INT((13-WEEKDAY(H41-1)+DAY(H41))/7)

 

[Matty]

=INT((13-WEEKDAY(H41-1)+DAY(H41))/7)

Good stuff, barry houdini.

Matty

 

[pedie]

Great, guys it worked now!
Thank alot for helping