| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
weeknum of the month
Hi I am Tanuja i need to know what week is it in a month not in a year is it
possible |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
weeknum of the month
Assuming that the date is in A1, and week 1 starts on the 1st (not 1st
Sun/Mon say), then =INT(DAY(A1)/7)+1 -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Tanuja Kandula" <Tanuja wrote in message ... Hi I am Tanuja i need to know what week is it in a month not in a year is it possible |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weeknum of the month | Setting up and Configuration of Excel | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| formula: First and last day in month | Excel Worksheet Functions | |||
| Month Year Date Format | Excel Worksheet Functions | |||
| Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
Hybrid Mode
