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
1293 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 BD Economic Survey 2021 book PDF download in one click

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

1 Ans BCS viva Hidden Tips and Tricks Read now

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

1 Ans 4 Major Bank Job circular image

3 Ans Download BD Bank all Job list Apply now payment with rocket seat plan admit card preliminary and final result download

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

1 Ans BB AD 2019 - 2020 circular seat plan and result download

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

2 Ans NSI Exam preparation Mark Distribution Question pattern details here


All Related Q/A