Showing posts with the label years

How Do You Subtract Dates In Excel To Get Years

In the example shown the formula in D6 is. DATE YEAR A2-5 MONTH A2 DAY A2 Above formula will give you a date exact 5 y…