Help with Text and Dates

[Wildwood]

I'm hoping someone on here can assist me....Both of these formulas are
returning #Name errors.......Please suggest alternative formulas....


Formula #1:
"ALL QUOTED LEASE FACTORS EXPIRE ON "&TEXT(EOMONTH(NOW(),0),"MMM-DD-YYYY")&"
AND ARE SUBJECT TO VERIFICATION PRIOR TO FUNDING"

Formula #2:
"QUOTED ASSUMPTIONS ARE VALID FROM "&TEXT(TODAY(),"MMM-DD-YYYY")&" -
"&TEXT(EOMONTH(NOW(),0),"MMM-DD-YYYY")&". LEASES MUST BE CASHED BEFORE
"&TEXT(EOMONTH(NOW(),1), "MMM-DD-YYYY")

 

[Luke M]

Make sure the Analysis ToolPak add-in is installed.

 

[Mike H]

Hi,

The formula are OK but you need to load the analysis toolpak.

Tools - Addins - Check 'analysis toolpak' OK

Select each formula cell tap F2 and enter
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Wildwood]

Awesome...That worked!!! Many, many thanks!

Hi,

The formula are OK but you need to load the analysis toolpak.

Tools - Addins - Check 'analysis toolpak' OK

Select each formula cell tap F2 and enter
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.