yearfrac function

[dickie12]

Recently I had to restore Microsoft Office. When accessing a spreadsheet
created before I restored the yearfrac is not recognized. How do I reload
this frunction?

 

[Jacob Skaria]

Install Analysis Tool Pak. From menu
Tools>AddIns>check 'Analysis ToolPak' and hit OK

If this post helps click Yes

 

[dickie12]

Response received and all is fine, thanks