Search the Q&A Archives

# I recently bought John Walkenbach's book Excel 2002...

<< Back to general questions

 Question by Brian Clifton Submitted on 4/16/2004 Related FAQ: N/A Rating: Not yet rated Rate this question: N/A Worst Weak OK Good Great I recently bought John Walkenbach's book Excel 2002 Formulas. In Chapter 6 "Working with Dates & Times" I came an Easter Calculator ( Page 165 ), which I tried. It worked perfectly, until a week or so ago, I tried it once more and it returned an #Value error. The Formula is: =DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1,19)-7,30)*14%,)*7-6 Is anyone able to solve this mistery out there?

 Answer by afmutw Submitted on 4/2/2006 Rating: Not yet rated Rate this answer: N/A Worst Weak OK Good Great I had the same problem, make sure A1 is the year only (i.e. just the number 2004) and not a date.

Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to general questions