try this
To return the week number of a date we can use the WEEKNUM formula. It will
return a number that indicates where the week falls numerically within a
year. If this function is not available, and returns the #NAME? error,
install and load the *Analysis ToolPak* add-in. That is, *Tools*>*Add
HI Have Greeting to all member
My self Alok I have some issue there some data which are in Aug
July-Jan(Execute Sheet) and I have data in Jan feb--Aug but I want
ot paste is in my execute sheet please suggest me
I hope ASAP
Thanks Ragard
Alok Dbs
-Original Message-
From
I am wondering if anyone can help me summarise some data. I have a
sheet which takes external data from a control system and reports an
alarm status...and I'd like to somehow summarise this on another sheet
so I can see just the times of the last time we went into alarm, and
the last time we came
You can use function *weeknum*
On Thu, Sep 18, 2008 at 3:49 PM, Lakshmanan T S <
[EMAIL PROTECTED]> wrote:
> Hi friends,
>
> Is there any predefined function or menu in Excel by which we can reflect
> the Week no inside a cell, if dates are entered in another cell?
> For example, the running week
Hi,
I have been working on this for a few days now and really at wits
end!! So any help would be greatly appreciated.
So far I have the following code:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)
Dim Rng As Range
Set Rng = Intersect(Target, Range("$A$4:$K")
Hi Dude...
Yes it is there for that you need to install add in - --- Analysis
Tool pack
the FUNCTION name is =WEEKNUM(A1).
hope this will work..
Thanks,
yogesh
2008/9/18 Lakshmanan T S <[EMAIL PROTECTED]>
> Hi friends,
>
> Is there any predefined function or menu
Hi friends,
Is there any predefined function or menu in Excel by which we can reflect
the Week no inside a cell, if dates are entered in another cell?
For example, the running week now is week no 38 of the year 2008. So if we
enter in cell A1 , 09/18/2008, can we get Week no 38 in A2 by way of a
Have you tried rebuilding the sheet from a fresh blank workbook?
(Assuming it's not TOO complex... otherwise it's a big job. )
"Me too" replies aren't helpful, but I have been having this behaviour
happen. My code does not delete ANY cells anywhere, nor am I doing
anything with the "Shapes" obje
Dear Friends
I dont know how to create a combo box in Excel sheet
Please help
--
Regards
Darshan Amreliya
Sr Engineer
Ispat Industries Limited
Cell No 09321063681
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot
