top of page

📣 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 >> https://www.chatstickmarket.com/langran Examples of various brands that we take care of online marketing >>https://www.chatstickmarket.com/portfolio ---------------------------------------------------------------------------------------  💙 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

📣 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

┗━━━━━━━━━┛

1 view
CS_Redesign_คอนเทนต์เดิม2_2.png
CS_Redesign_คอนเทนต์เดิม3.png
Recent Posts
c24f0332fa3b87f8a304140403b893510_64100212_210625.jpg
244712625_300456528129611_2152723951836713111_n.jpg
5.png
4.png
Button Event สติกเกอร์.png
2.png
Button ChatStick Market.png
bottom of page