Bheema
> > Sent: Monday, January 23, 2012 4:06 AM
> > To: excel-macros@googlegroups.com ; Sam Mathai Chacko
> > Subject: Re: $$Excel-Macros$$ Proportionate calculation
> >
> > Dear sir,
> >
> > I attached the excel file. An error is coming in calculati
oups.com ; Sam Mathai Chacko
> Subject: Re: $$Excel-Macros$$ Proportionate calculation
>
> Dear sir,
>
> I attached the excel file. An error is coming in calculation of the
> proportionate pay.
>
> Here, assume that every month should have only 30 days irrespective their
>
Without looking too close, try /30
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Shankar Bheema
Sent: Monday, January 23, 2012 4:06 AM
To: excel-macros@googlegroups.com ; Sam Mathai Chacko
Subject: Re: $$Excel-Macros$$ Proportionate calculation
Dear sir,
I attached the excel
thank you sir
On Sat, Jan 21, 2012 at 9:55 PM, Sam Mathai Chacko wrote:
> Private Sub CommandButton1_Click()
>
>Dim lngDays As Long, lngActualDays As Long
>On Error Resume Next
>lngDays = Day(DateSerial(Year(TextBox2.Value),
> Month(TextBox2.Value) + 1, 0))
>lngActualDays = lngDay
Private Sub CommandButton1_Click()
Dim lngDays As Long, lngActualDays As Long
On Error Resume Next
lngDays = Day(DateSerial(Year(TextBox2.Value),
Month(TextBox2.Value) + 1, 0))
lngActualDays = lngDays - Day(DateSerial(Year(TextBox2.Value),
Month(TextBox2.Value), Day(TextBox2.Value)
Dear Experts
I am attaching an excel form, in which according to the promotion date text
box the proportionate pay text box has to show in the command button event
the pay of that particular month according to the days calculation.
eg. if the pay is 1000/- pm (consider every calendar month shoul
