Thanks Sir, problem solved ...though the array seems complex for me to
understand...
Salute to Excel-Macros
With Best Regards.
On 9/15/10, ashish koul wrote:
>
> check the attachment see if it helps
>
> On Mon, Sep 13, 2010 at 11:57 AM, Nalini wrote:
>
>> Dear Sirs,
>>
>> I w
Hi,
Please see the attached for a possible solution.
Regards - Dave.
On Mon, Sep 13, 2010 at 11:57 AM, Nalini wrote:
Dear Sirs,
I want to capture data which employees are on leave as on date and
since when ?
Formula please…..
(Format enclosed)
NAME01-Sep 02-Sep 03-Sep 04-Sep 0
check the attachment see if it helps
On Mon, Sep 13, 2010 at 11:57 AM, Nalini wrote:
> Dear Sirs,
>
> I want to capture data which employees are on leave as on date and
> since when ?
> Formula please…..
>
> (Format enclosed)
>
> NAME01-Sep 02-Sep 03-Sep 04-Sep 05-Sep 06-Sep 07-Se
Dear Sir,
Problem partially solved. Result Cell should be blank if an employee is
already joined and now working.I have to find out continuous leave of an
employee from a particular date till today.Also highlight with colour thro.
conditional formating.
Enclosed file ...
Regards.
On 9/14/10, as
can you please attach excel file
On Mon, Sep 13, 2010 at 11:57 AM, Nalini wrote:
> Dear Sirs,
>
> I want to capture data which employees are on leave as on date and
> since when ?
> Formula please…..
>
> (Format enclosed)
>
> NAME01-Sep 02-Sep 03-Sep 04-Sep 05-Sep 06-Sep 07-Sep Leave
Dear Sirs,
I want to capture data which employees are on leave as on date and
since when ?
Formula please…..
(Format enclosed)
NAME01-Sep 02-Sep 03-Sep 04-Sep 05-Sep 06-Sep 07-Sep Leave Since
A AB AB AB AB AB AB AB 01-Sep
B pr pr
