【EXCEL】好用函數

【超連結】
=HYPERLINK(SourceString,ShowString)
例：=hyperlink("https://www.google.com.tw/","Google首頁")


【文字串串樂】
=CONCATENATE(stringA,StringB,...)
例：=CONCATENATE("I"," ","love"," ","YOU!!!")

【日期取年】
=YEAR(DATE)
例：=YEAR(DATE(2016,10,24))

【日期取月】
=MONTH(DATE)
例：=MONTH(DATE(2016,10,24))

【日期取日】
=DAY(DATE)
例：=DAY(DATE(2016,10,24))

☆不定期補充