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 |