To calculate a year based on a date entered in some cell you use the Excel YEAR function exactly in the same way as we did in the previous example. You now have your years extracted. You now have your result.
If we want to make sure that a user enters only a date in the current year then the formula to be used is YEAR C5YEAR TODAY.
Excel uses whole days between two dates to work out the fraction of a year as a decimal value. If the YEAR of the cell. Excel uses whole days between two dates to work out the fraction of a year as a decimal value. In the place of serial_number you have to select the cell that contains the date.