Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Manipulating a date to create a specific string
Message
From
22/09/2005 08:29:43
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
22/09/2005 07:58:10
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Microsoft Office
Category:
Excel
Miscellaneous
Thread ID:
01051896
Message ID:
01051909
Views:
7
This message has been marked as a message which has helped to the initial question of the thread.
>>>If I have a date in column A: 09/21/2005
>>>
>>>I need to get the following text string in column B: "09/20 & 09/21"
>>>
>>>The day and the prior day from the date in column A.
>>>
>>>Easy in Foxpro. Can't figure it out in Excel...
>>
>>Jay,
>>Try this
>>
=TEXT(MONTH(A1);0) & "/" & TEXT(DAY(A1)-1;0) & " & " & TEXT(MONTH(A1);0) & "/" & TEXT(DAY(A1);0)
>
>It's telling me that I have an error in the formula. Did you test it using a date in column A?

Did you change the delimiter, from ";" to ","? Outside the U.S. we often use ";" as a delimiter.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform