But the output is displayed as per the default format. In the above example, we had given the year as 1992, month as 10, and day as 30. As we give the details of it then this displays the date in default format as below: In the above function, we can observe that DATE is asking to provide values of Year, Month, Day. The result displayed is in date format, but the arguments are supplied as integers. In order to insert a specific valid date in excel, we have to use DATE() Use DATE() The date function in excel is a date and time function representing the number provided as arguments in a date and time code. Example #2 – Inserting Specific Date in Excel And the third observation, which is already in date format and we changed to number format, is displaying “43,495,” which says that today’s date, i.e., is exactly 43,495 days away from the cut-off date. Similarly, for the number 100, the date displayed is the exact count from. Here if we observe the number 50 has been changed to date and it displayed exactly 50 days from (including this date in the count).
0 Comments
Leave a Reply. |