software

Thanks


most vague--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: www.excelforum.com/member.php...foamp;userid=3472
View this thread: www.excelforum.com/showthread...hreadid=530525If it is a real Excel date, formatted as yyyymmdd:

=DATE(YEAR(A1),MONTH(A1) 1,1)

If however, it is the number 20060501:

=DATE(LEFT(A10,4),MID(A10,5,2) 1,1)

--
Kind regards,

Niek Otten

quot;JS1quot; gt; wrote in message ...
gt; Thanks
One way:

=DATE(YEAR(TODAY()),MONTH(TODAY()) 1,1)

format with Format/Cells/Number/Custom yyyymmdd

Or if you want Text output:

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()) 1,1),quot;yyyy mmddquot;)

In article gt;,
JS1 gt; wrote:

gt; Thanks

**** Many thanks, Excel Guru's :-) ****quot;JE McGimpseyquot; wrote:

gt; One way:
gt;
gt; =DATE(YEAR(TODAY()),MONTH(TODAY()) 1,1)
gt;
gt; format with Format/Cells/Number/Custom yyyymmdd
gt;
gt; Or if you want Text output:
gt;
gt; =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()) 1,1),quot;yyyy mmddquot;)
gt;
gt; In article gt;,
gt; JS1 gt; wrote:
gt;
gt; gt; Thanks
gt;