converting dates to decimal years

[davidbaker]

i need to convert dates dd/mm/yyyy to decimal years yy.yyyy but cannot
find an example of how this can be done. i would be grateful for
help?
thanks

 

[Bob Phillips]

Perhaps this

=TEXT(A8,"yyyy")+(A8-DATE(YEAR(A8),1,0))/(DATE(YEAR(A8)+1,1,0)-DATE(YEAR(A8)
,1,0))

and format as required

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[davidbaker]

thanks for that, but i am afraid this does not work as expected. if i
operate on 01/10/1998 the script returns 20/06/1905

further help needed !
thanks

 

[Bob Phillips]

As I said you need to format as required. You have it formatted as date.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[daddylonglegs]

What result do you expect for 01/10/1998?

Perhaps

=A1/365.2425+YEAR(0)

format as number

 

[davidbaker]

perfect thanks Bob