![]() To do this, you need to enter by manually the following value in the range C1:C3: = DATEDIF(A1 B1 «y»). Now you need to use the function to convert the number of days to the number of years. ![]() In the cells B1 : B3, you need to put the current date.In the new sheet in the cells A1: A3, you need to enter the dates: 18. ![]() Now we will learn how to calculate the age by date of birth: The calculating age by date of birth in Excel Accordingly, we get the number of days between these two dates. In the cell B1 you need to enter the formula: A3 - A1. It's not difficult to guess, to calculate the difference in dates in Excel, you need to take away the highest date from the newest date. Note that the «Date» format was automatically assigned to the cell A3.
0 Comments
Leave a Reply. |