>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)
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst