Can you find out how much those wages cost between quarter wise

[GVN KUMAR]

Can you find out how much those wages cost between 1,2,3
quarter and 4quarters?

I

Employee	Monthly Pay	Start Date	End Date	sum if	eo month
kishore	₹ 8,500.00​	05-Jan-21​	31-Mar-22​	₹ 1,17,903.23​	₹ 1,26,403.23​
kumar	₹ 8,500.00​	15-Apr-21​	25-Apr-22​	₹ 1,05,116.67​	₹ 1,05,116.67​
kamal	₹ 8,500.00​	04-May-21​	16-Apr-22​	₹ 97,210.75​	₹ 97,210.75​
kiran	₹ 8,500.00​	04-Aug-21​	16-Apr-22​	₹ 71,710.75​	₹ 71,710.75​

we are writing a formula for sumif and eo month but time lite variance to results

could correct sir

An employee has done so much that he is paid for working for a period of quarter wise ??

 

[vletm]

GVN KUMAR
Do You have clear image and answer:
Do their wages will pay 15th of each month or how?
How do their wages will calculate, if they have not worked full payment period?
... especially the 1st and the last ones.

 

[GVN KUMAR]

They are only hired to work for a while, sir

Sir the same people are hired by the supplier's sir

We are asking you how to prepare the expenses due in the following quarter balance sheet sir

q1 30-06-2021
q2 30-09-2021
q3 31-12-2021
q4 31-03-2022

We estimate their costs in this way
1-4-2021 to 30-6-2021
1-7-2021 to 30-9-2021
1-10-2021 to 31-12-2021
1-1-2022 to 31-3-2022

We are asking how to write a formula to evaluate as above sir

In our attempt to write down those dates as usual and correct the dates back and forth on those dates
We have written, sir
We asked if there was an easy way to solving sir

 

[vletm]

GVN KUMAR
You gave same information which I could read already.
Each company seems to have own rules for many things.
Okay ... only hired ... but
Do those get wage from only days, which those do work? ... hmm?
Now ,You seems to ask expenses due some periods?
Without knowing clear rules, there are challenges to offer formula to get expected results.

 

[GVN KUMAR]

ok sir

monthly consultancy nontechnical and unskilled staff pay for 8500/- for our outsourcing staff sir ( on day-wise salary for 26 days working sir )

 

[m9vukyem]

please find

 

[GVN KUMAR]

super sir

so much of time saving sir
thank you sir m9 vukyem