Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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") |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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") |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text to dates | Excel Discussion (Misc queries) | |||
Count Dates between Dates exclude Text | Excel Discussion (Misc queries) | |||
Dates from Text | Excel Worksheet Functions | |||
How do I convert dates stored as dates to text? | Excel Discussion (Misc queries) | |||
Format text 'dates' to real dates | Excel Worksheet Functions |