+ Reply to Thread
Results 1 to 14 of 14

leave type in payroll sheet with reference of from date - to date

  1. #1
    Registered User
    Join Date
    01-22-2021
    Location
    Hubli
    MS-Off Ver
    Microsoft office 2007
    Posts
    26

    leave type in payroll sheet with reference of from date - to date

    Hai, Please anyone can help me out
    i need Leave type in payroll sheet by reference to the Leave sheet with respect to employee id.
    if employee applied Leave for 5 days i.e 21-Mar-2021 to 25-Mar-2021 type of Leave should come in payroll sheet from date to to date[/PHP]
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: leave type in payroll sheet with reference of from date - to date

    C8=IFERROR(LOOKUP(2,1/((Manager_Leave!$E$2:$E$3>=$B$3+COLUMNS(C8:$C8)-1)*(Manager_Leave!$D$2:$D$3<=$B$3+COLUMNS(C8:$C8)-1)*(Manager_Leave!$A$2:$A$3=$A8)),Manager_Leave!$F$2:$F$3),"")

    Please try above formual, copy and paste across
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    01-22-2021
    Location
    Hubli
    MS-Off Ver
    Microsoft office 2007
    Posts
    26

    Re: leave type in payroll sheet with reference of from date - to date

    Thank u so much its working fine.
    sir please help me out for the same thing,. I'm getting confusion
    Attached Files Attached Files

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: leave type in payroll sheet with reference of from date - to date

    try below formula in C8

    =IFERROR(LOOKUP(2,1/((Manager_Leave!$F$2:$F$3>=$B$3+COLUMNS(B8:$B8)-1)*(Manager_Leave!$E$2:$E$3<=$B$3+COLUMNS(B8:$B8)-1)*(Manager_Leave!$A$2:$A$3=$A8)),Manager_Leave!$G$2:$G$3),"")

  5. #5
    Registered User
    Join Date
    01-22-2021
    Location
    Hubli
    MS-Off Ver
    Microsoft office 2007
    Posts
    26

    Re: leave type in payroll sheet with reference of from date - to date

    Sir, 4th row data on manager_leave is not coming in payroll sheet

  6. #6
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: leave type in payroll sheet with reference of from date - to date

    Extend range reference like below



    =IFERROR(LOOKUP(2,1/((Manager_Leave!$F$2:$F$30>=$B$3+COLUMNS(B8:$B8)-1)*(Manager_Leave!$E$2:$E$30<=$B$3+COLUMNS(B8:$B8)-1)*(Manager_Leave!$A$2:$A$30=$A8)),Manager_Leave!$G$2:$G$30),"")

  7. #7
    Registered User
    Join Date
    01-22-2021
    Location
    Hubli
    MS-Off Ver
    Microsoft office 2007
    Posts
    26

    Re: leave type in payroll sheet with reference of from date - to date

    Thank you so much.

  8. #8
    Registered User
    Join Date
    01-22-2021
    Location
    Hubli
    MS-Off Ver
    Microsoft office 2007
    Posts
    26

    Re: leave type in payroll sheet with reference of from date - to date

    sir if a type manually its working fine, but done it through userform its not working.
    Please Check it and let me know sir..
    Attached Files Attached Files
    Last edited by supmk; 02-25-2021 at 12:16 AM.

  9. #9
    Registered User
    Join Date
    01-22-2021
    Location
    Hubli
    MS-Off Ver
    Microsoft office 2007
    Posts
    26

    Re: leave type in payroll sheet with reference of from date - to date

    sir how do we refresh the data in one excel to another sheet?
    Last edited by supmk; 02-25-2021 at 12:41 AM.

  10. #10
    Registered User
    Join Date
    01-22-2021
    Location
    Hubli
    MS-Off Ver
    Microsoft office 2007
    Posts
    26

    Re: leave type in payroll sheet with reference of from date - to date

    Sir this is next level of Payroll management, I need to combine attendance sheet and all leave sheet and get the value of both sheet data in payroll sheet with respect to the date and of particular employee.
    You can run the userform for attendance Please do help me sir..
    Thank you
    Attached Files Attached Files
    Last edited by supmk; 02-25-2021 at 04:29 AM.

  11. #11
    Registered User
    Join Date
    01-22-2021
    Location
    Hubli
    MS-Off Ver
    Microsoft office 2007
    Posts
    26

    Re: leave type in payroll sheet with reference of from date - to date

    sir please help me sir...

  12. #12
    Registered User
    Join Date
    01-22-2021
    Location
    Hubli
    MS-Off Ver
    Microsoft office 2007
    Posts
    26

    Re: leave type in payroll sheet with reference of from date - to date

    sir please help me for this..
    i need both data from attendance sheet and manager_leave sheet with respect to the same employee
    how do compare two sheets??
    =IFERROR(VLOOKUP($B8&"_"&C$7,attendence!$A:$I,9,0),LOOKUP(2,1/((Manager_Leave!$F$2:$F$30>=$C$7+COLUMNS($B20:H20)-1)*(Manager_Leave!$E$2:$E$30<=$C$7+COLUMNS($B20:H20)-1)*(Manager_Leave!$A$2:$A$30=$A20)),Manager_Leave!$G$2:$G$30))
    i tried this formula but its not working
    Please help me out sir.
    Attached Files Attached Files

  13. #13
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: leave type in payroll sheet with reference of from date - to date

    try below formula in C8, Copy and paste across

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  14. #14
    Registered User
    Join Date
    01-22-2021
    Location
    Hubli
    MS-Off Ver
    Microsoft office 2007
    Posts
    26

    Re: leave type in payroll sheet with reference of from date - to date

    Thank you so much its working fine.... really great!!!!!!!
    sir please reply for thread #8

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Match names with leave type and date
    By acsishere in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-31-2019, 10:50 AM
  2. [SOLVED] Payroll forecast using start and stop date as well as potential raise date
    By plavi88 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2018, 11:06 AM
  3. Replies: 0
    Last Post: 09-01-2015, 05:33 AM
  4. Updating date to show next payroll date
    By Jpell577 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-24-2015, 10:13 AM
  5. [SOLVED]Find a closer date for payroll in a range of date
    By jackson_hollon in forum Excel General
    Replies: 9
    Last Post: 10-06-2014, 11:06 AM
  6. [SOLVED] get todays date in a cell and leave it as today's date?
    By dwest100 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2014, 02:49 PM
  7. How to leave Date formula cell blank until date entry??
    By NewbieDateFormatter in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-16-2011, 07:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1