I am updating a file for my boss. (I did not create) and it has a calendar that gets populated via formulas. I noticed when working on my laptop the values return as errors when I change the year, however on my desktop they do not. Does anyone know why this is happening, or what solutions I may have ?
I have uploaded a condensed file
Thanks
Joe
What values return as errors? Please specify the actual cells.
What version of Excel is on your laptop? On the laptop, do you still get errors if you remove "@" from the formulas?
The way you have set up your calendar looks like it was a huge amount of unnecessary work. Just FYI here is an example where Excel does the work for you.
i was able to implement yours. thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks