View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vadhimoo Vadhimoo is offline
external usenet poster
 
Posts: 10
Default 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.