Works spreadsheets

[DalesAtHome]

Can anyone please tell me if it is possible to save an Excel 2002 spreadsheet in a format that MS Works 8 will open...

I am using the datedif calculation i.e.. || =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days" || This will give me an answer like so...33 years, 9 months, 18 days ......

The calculation is fine on Excel but when I try to run it on my friends computer which only has Works 8 installed I just get error msgs... I have tried different "save as" types but without success so am wasting my time? is it possible? is there a similar calculation for Works 8 that will do the same job?

Yours

A Novice

thx

 

[Nick Hodge]

DATEDIF is not included in Works. It is actually only included in Excel as a compatibility issue for Lotus 1-2-3, as at one time, anything which would sell had to be compatible with the 'default spreadsheet' of the time.

The function was only in help in XL2000, showing how much Excel keeps it 'under wraps'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)


Can anyone please tell me if it is possible to save an Excel 2002 spreadsheet in a format that MS Works 8 will open...

I am using the datedif calculation i.e.. || =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days" || This will give me an answer like so...33 years, 9 months, 18 days ......

The calculation is fine on Excel but when I try to run it on my friends computer which only has Works 8 installed I just get error msgs... I have tried different "save as" types but without success so am wasting my time? is it possible? is there a similar calculation for Works 8 that will do the same job?

Yours

A Novice

thx