Hello guys in this post i am tell you how to calculate age in google sheets like Excel sheet and i also provide a steps to calculate age using google sheets formula.

To calculate age in Google Sheets, you will need to use the DATEDIF function. The `DATEDIF` function calculates the number of days, months, or years between two dates.

Here is the basic syntax for the `DATEDIF` function:

```=DATEDIF(start_date, end_date, unit) ```

• `start_date` is the start date for the age calculation.
• `end_date` is the end date for the age calculation.
• `unit` is the unit of time you want to use for the age calculation. Possible values are “Y” for years, “M” for months, and “D” for days.

For example, to calculate the number of years between January 1, 2000 and January 1, 2020, you could use the following formula:

```=DATEDIF(DATE(2000,1,1), DATE(2020,1,1), "Y") ```

This would return the result “20” to indicate that 20 years have passed between the two dates.

You can also use the `DATEDIF` function to calculate the number of months or days between two dates. For example, to calculate the number of months between January 1, 2000 and January 1, 2020, you could use the following formula:

```=DATEDIF(DATE(2000,1,1), DATE(2020,1,1), "M") ```

This would return the result “240” to indicate that 240 months have passed between the two dates.

## Here are the steps to calculate age in Google Sheets using the `DATEDIF` function:

2. Click on an empty cell to make it the active cell.
3. Type the `=DATEDIF` function into the active cell.
4. Enter the start date for the age calculation as the first argument of the `DATEDIF` function. You can use the `DATE` function to specify the start date in the format `DATE(year, month, day)`.
5. Enter the end date for the age calculation as the second argument of the `DATEDIF` function. Again, you can use the `DATE` function to specify the end date in the format `DATE(year, month, day)`.
6. Enter the unit of time you want to use for the age calculation as the third argument of the `DATEDIF` function. Use “Y” for years, “M” for months, or “D” for days.
7. Press Enter to complete the formula and calculate the age.

For example, to calculate the number of years between January 1, 2000 and January 1, 2020, you would use the following formula:

```=DATEDIF(DATE(2000,1,1), DATE(2020,1,1), "Y") ```

This would return the result “20” to indicate that 20 years have passed between the two dates.

## You might like this:

1. Netflix Clone Using HTML CSS
2. Transparent Login Form Using HTML CSS
3. Login Form Using HTML CSS