Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I create formula that turns a date into the week # in
THANK YOU!!!!!!!!!!!!!. this did the trick.
"JE McGimpsey" wrote: WEEKNUM will work if you have the Analysis Toolpak Add-in installed (Tools/Add-ins... check the appropriate checkbox). In article , don wrote: Don't know if I made sense when I typed this... 1/1/04 would be 1 for the 1st week in the year. 2/10/04 would be given value 6 for the 6th week of the year, etc. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Line or bar graphs for tracking stocks profit and loss. | Charts and Charting in Excel | |||
create a chart with a formula | Charts and Charting in Excel | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |