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