In A1 enter =TODAY(). In B1 enter the date you want to count the years, months, and days until.
In column C3, D3, and E3 enter =B1-A1. Right click on C3 and select custom, enter Y in the text box. Repeat for D3, but enter M instead of Y. Repeat again for E3 and enter in the custom format text box.
In column C3, D3, and E3 enter =B1-A1. Right click on C3 and select custom, enter Y in the text box. Repeat for D3, but enter M instead of Y. Repeat again for E3 and enter in the custom format text box.
0 comments:
Post a Comment