How to find the Day of week in a Month
 

Dear All,

Good morning, How can i find the "Day of week in Month".
For example :

In this month if i enter the date as 01/09/2007 , is should reply - 1 (this
01/09/2007 consider as first week of this month)

In this month if i enter the date from 02/09/2007 to 08/09/2007 , is should
reply - 2 (consider as second week of this month)

In this month if i enter the date from 09/09/2007 to 15/09/2007 , is should
reply - 3 (consider as third week of this month)

In this month if i enter the date from 16/09/2007 to 22/09/2007 , is should
reply - 4 (consider as fourth week of this month)

In this month if i enter the date from 23/09/2007 to 29/09/2007 , is should
reply - 5 (consider as fifth week of this month)

In this month if i enter the date from 30/09/2007 , is should reply - 6
(consider as sixth week of this month)


* I have to find out for the whole year , so if you please advice on this.


Thanks in advance for your reply.

Have a nice day..!


Thanks and Regards,
Vadhimoo.

How to find the Day of week in a Month
 

=WEEKNUM(A1)-34
With dates in Cell A1 and down, will do that. for September onwards.
Shoiuld you start from January 1, then omit the -34 part

--
Hth

Kassie Kasselman
Change xxx to hotmail


"Vadhimoo" wrote:

Dear All,

Good morning, How can i find the "Day of week in Month".
For example :

In this month if i enter the date as 01/09/2007 , is should reply - 1 (this
01/09/2007 consider as first week of this month)

In this month if i enter the date from 02/09/2007 to 08/09/2007 , is should
reply - 2 (consider as second week of this month)

In this month if i enter the date from 09/09/2007 to 15/09/2007 , is should
reply - 3 (consider as third week of this month)

In this month if i enter the date from 16/09/2007 to 22/09/2007 , is should
reply - 4 (consider as fourth week of this month)

In this month if i enter the date from 23/09/2007 to 29/09/2007 , is should
reply - 5 (consider as fifth week of this month)

In this month if i enter the date from 30/09/2007 , is should reply - 6
(consider as sixth week of this month)


* I have to find out for the whole year , so if you please advice on this.


Thanks in advance for your reply.

Have a nice day..!


Thanks and Regards,
Vadhimoo.