• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Days Calculation for Inbetween Joinees for salary

W

webmax

Member
Hi,
I have excel sheet with three datas
A Cell-Emp ID
B Cell -Date of Joining
C Cell - I given my Output what answer will come
Now i was calculating Salary for June month . One employee Joined on 6th Jun 21. I want if the employee joined before 1st of June then the output column will show the 30 days (June month total days). If the employee Joined after 1st June it will shown 30-(Date of Joined).
Example 30th June 2021- 6th June 2021 = 25 Days

Attaching the sheet for your reference.
Thanks
 

Attachments

  • salary calculation.xlsx
    9.2 KB · Views: 3
webmax
There is a conflict with 30-rule (two different days).
You can modify that date with cell E1.
 

Attachments

  • salary calculation.xlsx
    10 KB · Views: 11
thanks
can we put the date inside the formula instead of adding two cells E1 & F1 cell.
can you guide if that in that scenario.
 
webmax
Can we ... do You mean that can You and someone else there put data inside the formula?
If so, then You there can do it.
If You really would like to use fixed values in formula
... You could use eg date(year,month,day) instead my solution.
 
You must log in or register to reply here.
Back
Top