Followers

Friday, 7 December 2018

Useful Excel Trick in HR Payroll


Hey Friends...

As in HR there are some excel formula which makes our task easy.
Today will learn to know the exact years month and day from a specific date to till specific date.

Please follow... if you have any query please comment.

DOB
Today Date
Total Period
15-Aug-90
07-Dec-18
28Years 3Months 23Days

DOB
Today Date
Total Period
15-Aug-90
07-Dec-18
DATEDIF(A2,B2,"Y")&"Years "&DATEDIF(A2,B2,"YM")&"Months "&DATEDIF(A2,B2,"MD")&"Days "



-

1 comment:

Subscribe to: Post Comments (Atom)

Workday and Networkday Day Excel Function

In this video, you will learn about two very important Excel functions: WORKDAY and NETWORKDAYS. These functions are incredibly useful for a...

  • Ms Excel - Sum Average and Averageif
     In Ms Excel you must heard about the function Sum ,Average and Averageif. Here i have created on video which will help you to understand th...
  • Leave encashment
      Today we will talked about Leave encashment In case employee have not taken leaves and have opted for encashing those leaves, employer wou...
  • Workday and Networkday Day Excel Function
    In this video, you will learn about two very important Excel functions: WORKDAY and NETWORKDAYS. These functions are incredibly useful for a...