| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding week from date
I need to find the actual week from a date. If a date is
eg. 17.02.2004 it should return 7. Is there a function or calculator? Chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding week from date
You might want to look he
http://www.cpearson.com/excel/weeknum.htm Chip Pearson's page on ISO weeknumbers and Excel's weeknum function. -- Regards, Tom Ogilvy "Chris" wrote in message ... I need to find the actual week from a date. If a date is eg. 17.02.2004 it should return 7. Is there a function or calculator? Chris |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding week from date
Hi Mike!
You appear to be using the week numbering system where Jan-1 is start of week 1 and Jan-8 is start of week 2 etc. This gives you the formula: =INT((A1-DATE(2004,1,1))/7+1) Or to make it flexible for the current year: =INT((A1-DATE(YEAR(TODAY()),1,1))/7+1) But see: Chip Pearson: http://www.cpearson.com/excel/weeknum.htm Discusses week numbering -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Chris" wrote in message ... I need to find the actual week from a date. If a date is eg. 17.02.2004 it should return 7. Is there a function or calculator? Chris |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding week from date
Hi Chris,
I need to find the actual week from a date. If a date is eg. 17.02.2004 it should return 7. Is there a function or calculator? Activate the analysis toolpak addin (Tools, addins) and then use the Weeknumber function. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding week from date
Chris,
Not as simple as it at first sounds. Check out this previous post from Norman Harker, it gives good detail http://tinyurl.com/2xlg5 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Chris" wrote in message ... I need to find the actual week from a date. If a date is eg. 17.02.2004 it should return 7. Is there a function or calculator? Chris |
| Reply |
| 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) | |||
| Finding the week of date | Excel Discussion (Misc queries) | |||
| Finding the next dayof the week after a certain date. | Excel Worksheet Functions | |||
| Finding the date using the number of the week in a year | Excel Worksheet Functions | |||
| Finding the Monday date based on a different date in same week | Excel Worksheet Functions | |||
Hybrid Mode
