Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Wekk numbers and dates
i have a chart in which I need to match the week number up with the Saturday
of that week. Can someone suggest an easy way of doing this please thanks A |
#2
|
|||
|
|||
try this url
www.cpearson.com/excel/weeknum.htm ================= Alex H wrote in message ... i have a chart in which I need to match the week number up with the Saturday of that week. Can someone suggest an easy way of doing this please thanks A |
#3
|
|||
|
|||
Alex,
=DATE(2005,1,1)+(C1-1)*7 seems to work, where C1 is the weeknum, as defined in Excel (i,.e not ISO) -- HTH Bob Phillips "Alex H" wrote in message ... i have a chart in which I need to match the week number up with the Saturday of that week. Can someone suggest an easy way of doing this please thanks A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF USING DATES | Excel Discussion (Misc queries) | |||
Is there an automatic way to change numbers such as 12312001 t | Excel Discussion (Misc queries) | |||
converting dates into numbers | Excel Discussion (Misc queries) | |||
Combo Box Showing numbers not dates | Excel Discussion (Misc queries) | |||
micosoft excel dates entered but changed to sequencial numbers ho. | Excel Worksheet Functions |