Ask Question - Get Answer

2 Ans How to find Employee working day from his joining date?

Asked by Arif Hossain (4 Silvers) Tuesday, 11 Jul 2023, 04:22 PM at (Jobs Govt. Jobs)

Please log in to answer, like and save
639 Views
0
Save 0

<<< Previous
Log in to Answer Next >>>

Answer(s):

Determination of tenure on today's date: (Here D2 is joining date)


=DATEDIF(D2,TODAY(),"y")&" Year "&DATEDIF(D2,TODAY(),"ym")&" Month "&DATEDIF(D2,TODAY(),"md")&" Day "




Determining tenure on a specific date: (Here A2 is the joining date, B2 is the date on which the tenure will be calculated)


=DATEDIF(A2,B2,"y")&" year "&DATEDIF(A2,B2,"ym")&" month "&DATEDIF(A2,B2,"md")&" day "

Answered by Arif Hossain (4 Silvers) Tuesday, 11 Jul 2023, 04:23 PM

Please log in to Upvote, Downvote and Report
Upvote 0
0
0


আজকের তারিখে কর্মকাল নির্ণয়ঃ (এখানে D2 হল জয়েনিং তারিখ)


=DATEDIF(D2,TODAY(),"y")&" বছর "&DATEDIF(D2,TODAY(),"ym")&" মাস "&DATEDIF(D2,TODAY(),"md")&" দিন "




কোন নির্দিষ্ট তারিখে কর্মকাল নির্ণয়ঃ (এখানে A2 হল জয়েনিং তারিখ, B2 হল যে  তারিখে কর্মকাল বের করব)


=DATEDIF(A2,B2,"y")&" বছর "&DATEDIF(A2,B2,"ym")&" মাস "&DATEDIF(A2,B2,"md")&" দিন "



Answered by Arif Hossain (4 Silvers) Tuesday, 11 Jul 2023, 04:23 PM

Please log in to Upvote, Downvote and Report
Upvote 0
0
0
           

Related Q/A:

1 Ans Current all Army Job circular - Join Bangladesh Army - ISSB Date and Result

3 Ans Primary Assistant Teacher exam 2021 - 100% common suggestion - image and PDF download

1 Ans 16th NTRCA Job Circular is published 23 May, 2019

1 Ans ব্যাংক এর চাকরির সুযোগ সুবিধা - All Advantages of Bank job

1 Ans 44th BCS Preliminary Question with 100% Correct Solution

1 Ans BD Economic Survey 2021 book PDF download in one click

1 Ans 17th NTRCA circular admit card seat plan preliminary written and final viva result download - all in one

2 Ans Army all Job circular 2019

1 Ans How to register at IBAS ++

1 Ans Introduce yourself Model answers


All Related Q/A