Hi Subbu,
Assuming you have the date in Cell A1, use the following formula:-
=WEEKNUM(A1)
Use following for Week Day
=WEEKDAY(A1,2)
Thanks
DILipandey (Back from Holidays)
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi -
Hello fnds I m sandeep. i m new member of excel maros group. i m from
delhi.
can some budy help me to learn maros functions. i will realley
appricate, if u send me any matarial which is helpfull to learn macro or
function's plzz send me ...
Regards: ╚►♥ѕαη∂єєρ♥◄╝
Hi,
Try the following:
=WEEKNUM(TODAY())
Regards - Dave.
Date: Tue, 14 Jul 2009 19:57:18 -0700
Subject: $$Excel-Macros$$ how to get the week no in a function
From: subbu1...@gmail.com
To: excel-macros@googlegroups.com
hi
can you pls tell me the function to get the week no of a