Excel Spreadsheet - YEARFRAC

  pcdimwit 19:18 05 Feb 04

Am trying to calc the years between todays date and earlier time but having trouble getting formula right.

Cell N1 has date, say 29-SEP-1998
Cell P1 is todays date
want 360 day yr count

Formula used:

Get a resulting #NAME?

Can someone tell me what am I doing wrong.

  TonyV 20:35 05 Feb 04

I have just tried the same formula that you have used and got the same result. I then went into the Help system and found I had to use one of the Addins. I then clicked on Tools/Addins then checked Analysis Toolpak and went through the simple install bit. I then went in to Excel and used the same formula that you have and came up with the answer 5.4305556.
Try it and see.

  VoG II 21:29 05 Feb 04

Yep, you need the Analysis Toolpak

An alternative (that doesn't need the Toolpak) is DATEDIF, e.g.


  pcdimwit 15:21 06 Feb 04

TonyV & VoG,
Both solutions work.
Thanks for your help

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

Hands-on: Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too

47 iPhone camera tips to help you take better photos