Week
Hi Stefi,
Cannot get it.
May I know what is returns 12 and Analysis Toolpak is needed mean?
"Stefi" wrote:
If A1 contains 22/3/2010 as a real Excel date then
=WEEKNUM(A1,1)-1
returns 12.
Analysis Toolpak is needed!
--
Regards!
Stefi
€žSky€ť ezt Ă*rta:
Hi,
I had a file with different date on it.
If I need to consolidate them into week.
example
4 Jan to 10 Jan is call week 1
11 Jan to 17 jan is week 2
is it possible to calculator 22 Mar is in which week(week 12)
|