workdays

[ahhhmed]

How to count a working period by:

years,

months,

weeks,

and days?

 

[vasim]

use networkdays formula..........

 

[ahhhmed]

Thanks,

My question is about the difference between two dates in years, monthe, weeks or days.

 

[Krishnaoptif]

Hi ahhhmed,


Please use the below formula and will get right ans for your Qus..


For Year


=DATEDIF(E12,TODAY(),"y")

=DATEDIF(StartDate,EndDate,"y")


For Months


=DATEDIF(E12,TODAY(),"ym")

=DATEDIF(StartDate,EndDate,"ym")


For Days


=DATEDIF(E12,TODAY(),"md")

=DATEDIF(StartDate,EndDate,"md")


Regards,

Krishna

9560305552

 

[ahhhmed]

Thanks for help