Bulk Age Calculator MS Excel Tricks এম এস এক্সেল বয়স গণনা সূত্র

in #tutorial6 years ago

If you want to calculate age in Years, Months & Days in excel then you have to use Datedif formula. This formula is hidden feature in excel. Before using this formula, you should have proper date format. Otherwise this formula will not work properly. So ensure correct date format to get desired result.

আপনি বছর, মাস এবং এক্সেল মধ্যে বয়স গণনা করতে চান তাহলে আপনি Datedif সূত্র ব্যবহার করতে হবে।

Use the 'datedif" for conditional formula, "Y" for year, "YM" for Months, "MD" for Date. Lets check the video.....

=> to get updates, Follow me on Steemit

Sort:  

Congratulations @smkhalidiu! You have completed the following achievement on Steemit and have been rewarded with new badge(s) :

Award for the number of upvotes received

Click on the badge to view your Board of Honor.
If you no longer want to receive notifications, reply to this comment with the word STOP

Do not miss the last post from @steemitboard:
SteemitBoard World Cup Contest - The semi-finals are coming. Be ready!


Participate in the SteemitBoard World Cup Contest!
Collect World Cup badges and win free SBD
Support the Gold Sponsors of the contest: @good-karma and @lukestokes


Do you like SteemitBoard's project? Then Vote for its witness and get one more award!

Congratulations @smkhalidiu! You received a personal award!

Happy Birthday! - You are on the Steem blockchain for 1 year!

You can view your badges on your Steem Board and compare to others on the Steem Ranking

Do not miss the last post from @steemitboard:

SteemitBoard - Witness Update
SteemitBoard to support the german speaking community meetups
Vote for @Steemitboard as a witness to get one more award and increased upvotes!