Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get the week in month from a date? | Excel Worksheet Functions | |||
Change day of week to day of month | Excel Discussion (Misc queries) | |||
Day, Week or Month | Excel Discussion (Misc queries) | |||
Name The Week Of The Month | Excel Discussion (Misc queries) | |||
Week of the Month | Excel Discussion (Misc queries) |