| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
simple week entry
One way..
=INT(DATEDIF(DATE(YEAR(A1),MONTH(A1),1),A1,"d")/7+1) If this post helps click Yes --------------- Jacob Skaria "aditya" wrote: if in cell A1 date is given, how can i do week entry of the month in cell B1/B2. e.g. A1=2-APR 09 B1=1st Week A2=28- Mar 09 B2=4th Week A3=9-Feb 09 B3= 2nd week |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| week entry new | Excel Discussion (Misc queries) | |||
| week entry | Excel Discussion (Misc queries) | |||
| week entry | Excel Discussion (Misc queries) | |||
| Automatically Insert Dates For Week Off One Day Entry | Excel Discussion (Misc queries) | |||
| day of the week entry automatically | Excel Worksheet Functions | |||
Threaded Mode
