lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I am reading the article below. I know how to use Date() but I really can not see any use or befit of this function. The author gave some examples but again I do not see any use of these examples. Can you please give me examples where I really need to use date() function. Thank you so much.
<code style="font-family: "Courier new"; white-space: pre-wrap; color: rgb(69, 69, 69); font-weight: 600;">=DATE(2015, 5, 20)</code> - returns a serial number corresponding to 20-May-2015.
<code style="font-family: "Courier new"; white-space: pre-wrap; color: rgb(69, 69, 69); font-weight: 600;">=DATE(YEAR(TODAY()), MONTH(TODAY()), 1)</code> - returns the first day of the current year and month.
<code style="font-family: "Courier new"; white-space: pre-wrap; color: rgb(69, 69, 69); font-weight: 600;">=DATE(2015, 5, 20)-5</code> - subtracts 5 days from May 20, 2015.
https://www.ablebits.com/office-addins-blog/2015/06/10/excel-date-functions/
I am reading the article below. I know how to use Date() but I really can not see any use or befit of this function. The author gave some examples but again I do not see any use of these examples. Can you please give me examples where I really need to use date() function. Thank you so much.
<code style="font-family: "Courier new"; white-space: pre-wrap; color: rgb(69, 69, 69); font-weight: 600;">=DATE(2015, 5, 20)</code> - returns a serial number corresponding to 20-May-2015.
<code style="font-family: "Courier new"; white-space: pre-wrap; color: rgb(69, 69, 69); font-weight: 600;">=DATE(YEAR(TODAY()), MONTH(TODAY()), 1)</code> - returns the first day of the current year and month.
<code style="font-family: "Courier new"; white-space: pre-wrap; color: rgb(69, 69, 69); font-weight: 600;">=DATE(2015, 5, 20)-5</code> - subtracts 5 days from May 20, 2015.
https://www.ablebits.com/office-addins-blog/2015/06/10/excel-date-functions/