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
600 Views
0
Save 0

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

Answer(s):


আজকের তারিখে কর্মকাল নির্ণয়ঃ (এখানে 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

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
           

Related Q/A:

1 Ans 41th BCS Preliminary Exam full question solution

4 Ans 41th BCS Circular - ৪১ তম বিসিএস বিজ্ঞপ্তি seat plan result PDF download

1 Ans Primary Assistant Teacher Recruitment Exam 2018 - 2019, Final result has been released, 18,147 candidates are recruited

8 Ans 40th BCS all Subject Written Questions Download

2 Ans 41th BCS Preliminary Date is about to publish now

1 Ans IBAS ++ online pay fixation link for govt employees of BD

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

3 Ans Primary job circular 2020 notice admit card seat plan and result download

1 Ans Introduce yourself Model answers

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


All Related Q/A