Excel/ How to convert number of date to

93 Views Asked by At

How can I convert number of date to number of month or year.
Such as..

Number of Date: 40
Number of Month: ?
Number of Year: ?
1

There are 1 best solutions below

0
On BEST ANSWER

Month and Year functions

If this is what you want
enter image description here

then this is how you do it
enter image description here