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
751 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:

2 Ans How to choose a cadre in BPSC BCS examination application form fill up - learn the secret mystery

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

1 Ans 38th BCS circular PDF and image download directly from this

1 Ans BCS viva Hidden Tips and Tricks Read now

1 Ans BCS Mental Ability hand note (both preliminary and written)

2 Ans Bangladesh Railway Job Circular 2019 and Exam Result

3 Ans Bangladesh Army New Job Circular 2019 Download Now

2 Ans 2550 Senior Staff Nurse recruitment circular and result by BPSC - Apply Now

1 Ans Introduce yourself Model answers

6 Ans NSI Assistant Director question and solution 2019 download now


All Related Q/A