Help with Text and Dates
 

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")

Help with Text and Dates
 

Make sure the Analysis ToolPak add-in is installed.

--
Best Regards,

Luke M
"Wildwood" wrote in message
...
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")

Help with Text and Dates
 

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" wrote:

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")

Help with Text and Dates
 

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

"Mike H" wrote:

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" wrote:

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")