| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question using dates in a statement
I am currently trying to write a statement that uses two dates from another
worksheet (same workbook) as a title for the first worksheet. However, when I insert the cells into the statement, the date values do not appear. My statement looks like: ="Date Range: " & DataRange!A2 & " to " & DataRange!B2 The output looks like: Date Range: 39075 to 39081 Is there a way to convert the numeric values into dates in this statement? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question using dates in a statement
Use the TEXT() function to format the dates.
-- Gary's Student "Wink20TCU" wrote: I am currently trying to write a statement that uses two dates from another worksheet (same workbook) as a title for the first worksheet. However, when I insert the cells into the statement, the date values do not appear. My statement looks like: ="Date Range: " & DataRange!A2 & " to " & DataRange!B2 The output looks like: Date Range: 39075 to 39081 Is there a way to convert the numeric values into dates in this statement? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question using dates in a statement
="Date Range: " & text(datarange!a2,"mm/dd/yyyy") & ....
Use the format you like. Wink20TCU wrote: I am currently trying to write a statement that uses two dates from another worksheet (same workbook) as a title for the first worksheet. However, when I insert the cells into the statement, the date values do not appear. My statement looks like: ="Date Range: " & DataRange!A2 & " to " & DataRange!B2 The output looks like: Date Range: 39075 to 39081 Is there a way to convert the numeric values into dates in this statement? Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates Formatting Question - What if you do not know month and/or d | Excel Discussion (Misc queries) | |||
| Dates with Holidays question | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| IF Statement Question 0 values & blank cells | Excel Worksheet Functions | |||
| If Statement Question | Excel Worksheet Functions | |||
Hybrid Mode
