Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have this formula in a cell
=D12+1&" - " &D12+5 It produces this : 39528 - 39532 The cell format in the cell shows as m/dd/yy D12 = 3/20/08 I would like it to produce 3/21/08 - 3/25/08 If I lose everyting in the cell except the D12+1, the result is the correct date. I believe the & is causing the format to change to the date#'s instead of the date. How can I get the cell to produce 3/21/08 - 3/25/08 ? Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to Change Changing Date Format Data to Text | Excel Discussion (Misc queries) | |||
Changing text to date format | Excel Discussion (Misc queries) | |||
changing text to date format | Excel Worksheet Functions | |||
Formula for changing date format | Excel Worksheet Functions | |||
How to format date as text without changing appearance? | Excel Discussion (Misc queries) |