Open Office

octal 17:55 07 Feb 2009
Locked

I've been setting up a spreadsheet today and I've noticed there's no command DATEIF in OpenOffice, has anyone else noticed this and if so have you managed to get around it? I would have thought that they would have included it in the most recent version, still, I can't complain too much for a free software.

VoG II 18:00 07 Feb 2009

If you mean DATEDIF see the suggestion from barry houdine (Post # 12) click here

octal 19:00 07 Feb 2009

Thanks VoG™, yes it is DATEDIF, just a typo on my part.

I've copied that formula and I'll have a play with it to see how it works.

octal 20:06 07 Feb 2009

As a matter of interest I used this formula:
=YEARS(D4,NOW(),G4)

D4 is the delivery date of the equipment, G4 is the expected life of the equipment in years and of course NOW() is today's date, the result gives the actual age of the equipment.

This all part of a bigger spreadsheet that calculates when items of equipment should be replaced in any particular year given the expected life of it. It all works a treat, but is the YEAR statement also used in Excel as well? If it is then thankfully it will be compatible between the two systems.

VoG II 08:45 08 Feb 2009

Unfortunately there is no YEARS function in Excel.

Can you explain in words what that formula is calculating?

VoG II 09:23 08 Feb 2009

Perhaps if you are trying to calculate remaining life

=G4-(YEAR(TODAY())-YEAR(D4))

Strawballs 14:03 08 Feb 2009

octal 15:45 08 Feb 2009

The formula I gave in post Sat, 07/02/[email protected]:06 does work perfectly. If I need to run it in Excel then I can just substitute the YEARS for DATEDIF formula when the time comes, it's not a big problem.

It's a five year equipment replacement plan which I put together. It's a bit difficult to explain unless you actually see the spreadsheet, so I've taken a picture of it click here

The variables that need to be entered are the DEL_DATE, REPL_COST and the AGE LIMIT and the sheet will calculate in what year the equipment needs to be replaced and the expenditure for that year at the bottom.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

InVision Studio takes on Adobe XD and Sketch

Camera tips to take better iPhone photos

Comment transformer un iPhone en borne Wi-Fi ?