View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wildwood Wildwood is offline
external usenet poster
 
Posts: 7
Default 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")