xcel-mac...@googlegroups.com] *On Behalf Of *Ashish Pradhan
>> *Sent:* Sunday, June 28, 2009 2:41 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Re: Help with Attendance Tracker & Salary
>> Calculation
>>
>>
>>
>>
t;
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Ashish Pradhan
> *Sent:* Sunday, June 28, 2009 3:01 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Help with Attendance Tracker & Salary
> C
out of if().
Ignore the INT() stuff. That is wrong.
Regards,
Ajit
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ashish Pradhan
Sent: Sunday, June 28, 2009 3:01 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Help with Attendanc
Regards
Ajit
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ashish Pradhan
Sent: Sunday, June 28, 2009 2:41 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Help with Attendance Tracker & Salary
Calculation
Hi Ajit
Thanks for the pro
Hi Ajit
Thanks for the prompt response. Let me try your solution and revert back. (I
thought I was missing something, just wasnt sure if it was relatively easy
or a bit complicated)
Thanks once again.
Ashish
"Of what use is freedom if it does not include the freedom to make mistakes"
-- Mahat
HI,
Your post itself has the answer.
You say that even-if the person has worked all the days in a month, salary
Is paid for 30 days. That is you are assuming a month to be of 30 days. For
months with >30 days in them, the calculation of yours (Monthly Salary *
(No. of Days Present / 30)), y
