Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"As of" & "July 31, 2005"
Sheet 1
A1 = 7/31/05 (formated as date) = July 31, 2005 Sheet 2 I want A3 to read "As of July 31, 2005". But I want the date to be pulled from sheet 1, cell A1. So if I change sheet 1, A1 to August 31, 2005, then Sheet 2, A3 changes to read "As of August 31, 2005". How is this done? Thanks. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"As of" & "July 31, 2005"
Try this formula in A3:
="As of "&A1 "Tim Russell" wrote: Sheet 1 A1 = 7/31/05 (formated as date) = July 31, 2005 Sheet 2 I want A3 to read "As of July 31, 2005". But I want the date to be pulled from sheet 1, cell A1. So if I change sheet 1, A1 to August 31, 2005, then Sheet 2, A3 changes to read "As of August 31, 2005". How is this done? Thanks. *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"As of" & "July 31, 2005"
In Cell A3 Sheet2 enter
="As of " & TEXT(Sheet1!A1,"mmmm dd, yyyy") "Tim Russell" wrote in message ... Sheet 1 A1 = 7/31/05 (formated as date) = July 31, 2005 Sheet 2 I want A3 to read "As of July 31, 2005". But I want the date to be pulled from sheet 1, cell A1. So if I change sheet 1, A1 to August 31, 2005, then Sheet 2, A3 changes to read "As of August 31, 2005". How is this done? Thanks. *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
"As of" & "July 31, 2005"
sorry.. another way is to custom format the cell. you could do "As of "mmmm
d, yyyy "Kasey Kern" wrote: Try this formula in A3: ="As of "&A1 "Tim Russell" wrote: Sheet 1 A1 = 7/31/05 (formated as date) = July 31, 2005 Sheet 2 I want A3 to read "As of July 31, 2005". But I want the date to be pulled from sheet 1, cell A1. So if I change sheet 1, A1 to August 31, 2005, then Sheet 2, A3 changes to read "As of August 31, 2005". How is this done? Thanks. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE") | Excel Programming |