| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Week numbers from an entered date
I have a small sheet of allocated work / cases to be seen, in column
C cells would like the WEEK number to be automatically entered when the allocation date is entered into column D cells. Or the other way round e.g. I dont mind making column C the date then column D the week number. EG WEEK Allocated A B C D X X 24 17/6/11 thanks John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
| how do i stop excel from converting numbers entered into a date | Excel Discussion (Misc queries) | |||
| generate serial numbers and date it entered | Excel Discussion (Misc queries) | |||
| How do I get a cell to show the day of the week when date entered | Excel Discussion (Misc queries) | |||
| Transpose week numbers to date | Excel Discussion (Misc queries) | |||
![Johnnyboy5[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
