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

3 Ans 41st BCS Mental Ability full Question Solution

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

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

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

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

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

1 Ans Introduce yourself Model answers

1 Ans 4 Major Bank Job circular image

1 Ans BD national salary scale 2015 picture


All Related Q/A