CODEWITHSUNDEEP
exceldatedate-formattingdate-conversion
zzaewon
zzaewon

Reputation: 29

Excel/ How to convert number of date to

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: ?

Upvotes: 0

Views: 44

Answers (1)

kolcinx
kolcinx

Reputation: 2233

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

Upvotes: 1

Related Questions