#NAME?

  • Thread starter Thread starter Mpollock
  • Start date Start date
M

Mpollock

Good Afternoon:

Anyone who can help me with this would be a life saver. Below is the formula
we have been using for years and now for some reason today #NAME? is popping
up and we can not understand why when all of our databases are using this
same formula but for some reason it is no longer working in this one.

=IF(OR(I4="V",I4="VNR",H4="M",T4="MKT"),"n/a",IF(I4<>"Y","n/a",1+EOMONTH(BB4,11)))

This is so that we know when the next due date is.

Thank You-
Miranda Pollock
 
Miranda

The EOMONTH function is part of the Analysis Toolpak an Excel add-in for
statistical and engineering functions. Go to Tools>Add-Ins... and check it
in the list (not the one for VBA) and all should be well.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk
 
Back
Top