software

Hi All,

Sheet1 has date in A1 (1/1/2005) formated as Date.

Sheet2:
'=IF(Sheet1!A1gt;1,quot;MyDatequot; amp; Sheet1!A1) lt;- formated as Date
and
'=quot;MyDatequot;amp;IF(Sheet1!A1gt;1,Sheet1!A1) lt;-formated as Date

Both display -gt; MyDate38353

How can i make it display -gt; MyDate1/1/2005

Any direction?--
Desert Piranha------------------------------------------------------------------------
Desert Piranha's Profile: www.excelforum.com/member.php...oamp;userid=28934
View this thread: www.excelforum.com/showthread...hreadid=492963=quot;My Date quot;amp;TEXT(A1,quot;m/d/yyyyquot;)

--
Regards,

Peo Sjoblom

(No private emails please)quot;Desert Piranhaquot;
lt;Desert.Piranha.1zyrxa_1134453003.5104@excelforu m-nospam.comgt; wrote in
message newsesert.Piranha.1zyrxa_1134453003.5104@excelfo rum-nospam.com...
gt;
gt; Hi All,
gt;
gt; Sheet1 has date in A1 (1/1/2005) formated as Date.
gt;
gt; Sheet2:
gt; '=IF(Sheet1!A1gt;1,quot;MyDatequot; amp; Sheet1!A1) lt;- formated as Date
gt; and
gt; '=quot;MyDatequot;amp;IF(Sheet1!A1gt;1,Sheet1!A1) lt;-formated as Date
gt;
gt; Both display -gt; MyDate38353
gt;
gt; How can i make it display -gt; MyDate1/1/2005
gt;
gt; Any direction?
gt;
gt;
gt; --
gt; Desert Piranha
gt;
gt;
gt; ------------------------------------------------------------------------
gt; Desert Piranha's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28934
gt; View this thread: www.excelforum.com/showthread...hreadid=492963
gt;Try:

=IF(Sheet1!A1gt;1,quot;MyDatequot;amp;TEXT(Sheet1!A1,quot;dd/mm/yyyyquot;),quot;quot;)

Hope this helps
Rowan

Desert Piranha wrote:
gt; Hi All,
gt;
gt; Sheet1 has date in A1 (1/1/2005) formated as Date.
gt;
gt; Sheet2:
gt; '=IF(Sheet1!A1gt;1,quot;MyDatequot; amp; Sheet1!A1) lt;- formated as Date
gt; and
gt; '=quot;MyDatequot;amp;IF(Sheet1!A1gt;1,Sheet1!A1) lt;-formated as Date
gt;
gt; Both display -gt; MyDate38353
gt;
gt; How can i make it display -gt; MyDate1/1/2005
gt;
gt; Any direction?
gt;
gt;


Peo amp; Rowan,
Thx much, Both work fine.
Thx Again
Dave
Rowan Drummond Wrote:
gt; Try:
gt;
gt; =IF(Sheet1!A1gt;1,quot;MyDatequot;amp;TEXT(Sheet1!A1,quot;dd/mm/yyyyquot;),quot;quot;)
gt;
gt; Hope this helps
gt; Rowan
gt;
gt; Desert Piranha wrote:
gt; gt; Hi All,
gt; gt;
gt; gt; Sheet1 has date in A1 (1/1/2005) formated as Date.
gt; gt;
gt; gt; Sheet2:
gt; gt; '=IF(Sheet1!A1gt;1,quot;MyDatequot; amp; Sheet1!A1) lt;- formated as Date
gt; gt; and
gt; gt; '=quot;MyDatequot;amp;IF(Sheet1!A1gt;1,Sheet1!A1) lt;-formated as Date
gt; gt;
gt; gt; Both display -gt; MyDate38353
gt; gt;
gt; gt; How can i make it display -gt; MyDate1/1/2005
gt; gt;
gt; gt; Any direction?
gt; gt;
gt; gt;--
Desert Piranha------------------------------------------------------------------------
Desert Piranha's Profile: www.excelforum.com/member.php...oamp;userid=28934
View this thread: www.excelforum.com/showthread...hreadid=492963You're welcome.

Desert Piranha wrote:
gt; Peo amp; Rowan,
gt; Thx much, Both work fine.
gt; Thx Again
gt; Dave
gt; Rowan Drummond Wrote:
gt;
gt;gt;Try:
gt;gt;
gt;gt;=IF(Sheet1!A1gt;1,quot;MyDatequot;amp;TEXT(Sheet1!A1,quot;dd/mm/yyyyquot;),quot;quot;)
gt;gt;
gt;gt;Hope this helps
gt;gt;Rowan
gt;gt;
gt;gt;Desert Piranha wrote:
gt;gt;
gt;gt;gt;Hi All,
gt;gt;gt;
gt;gt;gt;Sheet1 has date in A1 (1/1/2005) formated as Date.
gt;gt;gt;
gt;gt;gt;Sheet2:
gt;gt;gt;'=IF(Sheet1!A1gt;1,quot;MyDatequot; amp; Sheet1!A1) lt;- formated as Date
gt;gt;gt;and
gt;gt;gt;'=quot;MyDatequot;amp;IF(Sheet1!A1gt;1,Sheet1!A1) lt;-formated as Date
gt;gt;gt;
gt;gt;gt;Both display -gt; MyDate38353
gt;gt;gt;
gt;gt;gt;How can i make it display -gt; MyDate1/1/2005
gt;gt;gt;
gt;gt;gt;Any direction?
gt;gt;gt;
gt;gt;gt;
gt;
gt;
gt;