Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / September 2007

Tip: Looking for answers? Try searching our database.

How to find the Day of week in a Month

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Vadhimoo - 22 Sep 2007 06:18 GMT
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.
kassie - 22 Sep 2007 08:38 GMT
=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

Signature

Hth

Kassie Kasselman
Change xxx to hotmail

> Dear All,
>
[quoted text clipped - 27 lines]
> Thanks and Regards,
> Vadhimoo.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.