Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |