Excel西元轉民國：日期函數、文字合併、數值格式
Synopsis
Excel有需要將西元日期轉換為民國的表達方式，本影片介紹如何設計日期函數取得年月日等資料，再利用文字合併及自訂數值格式 ...
You Might Also Like
![[EXCEL 佳檢學]文字日期轉西元日期，計算年齡及性別。](https://i.ytimg.com/vi/GyjK8TS3RTE/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGAFwAcABBvABAfgB_gmAAtAFigIMCAAQARgmIGUoMjAP&rs=AOn4CLDYA1VFKHACLcSl12zNE3y9ntCIAw)
Download Options
Choose a download method below. All links open in new tabs.
| Service | Features | Action |
|---|---|---|
| Ssvid |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
| SaveFrom |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.