YEAR(), the English version of the YEAR () insuradet year corresponding to a given date. Year is defined as an integer in the range from 1900 to 9999.
Find the number of days remaining until the end of the year.
Find the ordinal day of the year, for example, 25/01/2009 – the 25th day of the year.
Define the number of days in year (365 or 366).
When calculating time intervals, the result may turn out in years with a fraction of (6.9 years). Determine how many months is 0.9 years. the Result is written in the form: 6 years / 10 months.
If you know the week number, you can find the date of the last day of this week.
There are 2 ways of determining week numbers: in line with ISO standard and using functions WEEKNUM().
Determine how many years, months and days have passed since a certain date, and also solve the inverse problem.
Determine the age (or experience) in completed years.