📣 Calculate age with excel
📣 Calculate age with excel
Many people may have to spend time figuring out how to calculate days/months/years, either using a calculator or using a formula and doing the calculations by themselves. But today our article recommends a faster and better way. What kind of method is that? Let's go see it.
DATEDIF formula
After we type the data into the Excel program, we will use the method of filling the formula down to the system of the program to help calculate. Please try the next steps.
=DATEDIF(date cell,TODAY(), “Display Format”)
calculate the year
=DATEDIF(date cell,TODAY(), “Y”)
calculate the month
=DATEDIF(date cell,TODAY(), “YM”)
calculate the day
=DATEDIF(date cell,TODAY(), “MD”)
After that, notice in the right corner of the line grid where we put the calculated result and drag the mouse all the way down. The table will automatically calculate it. It's very easy and time-saving. Is that right?
-------------------------------------------------------------------------------------
Interested in online marketing care services | online marketing | complete graphics | can contact us anytime | brand building | online marketing | online marketing plan | brand building | Facebook fan page care | Take care of LINE OA. You can contact us 24 hours a day.
Details of online marketing services
Examples of various brands that we take care of online marketing
---------------------------------------------------------------------------------------
💙 Consult our team 💙
📱Tel : 0840104252 📱0947805680
Office Hotline : 034-900-165 , 02-297-0811 (Monday-Friday)
📨 Inbox : http://m.me/ChatStick.TH
┏━━━━━━━━━┓
📲 LINE: @chatstick
┗━━━━━━━━━┛
or click https://goo.gl/KuzCpM
🎉 details at http://www.chatstickmarket.com/langran
🎉 See our work at https://www.chatstickmarket.com/portfolio
Comentarios