Asked by
Arif Hossain (4 Silvers)
Tuesday, 11 Jul 2023, 04:22 PM
at (Jobs
Govt. Jobs)
|
|
|
|
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 |
আজকের তারিখে কর্মকাল নির্ণয়ঃ (এখানে 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")&" দিন " |
|
|
|
|
|
|
|
|
|
|