Help make a date = Day 1 of the next month ie. 20060501, 20060601
 

Thanks

Help make a date = Day 1 of the next month ie. 20060501, 20060601
 

most vague


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=530525

Help make a date = Day 1 of the next month ie. 20060501, 20060601
 

If 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

"JS1" wrote in message ...
Thanks

Help make a date = Day 1 of the next month ie. 20060501, 20060601
 

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),"yyyy mmdd")

In article ,
JS1 wrote:

Thanks

Help make a date = Day 1 of the next month ie. 20060501, 20060
 

**** Many thanks, Excel Guru's :-) ****


"JE McGimpsey" wrote:

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),"yyyy mmdd")

In article ,
JS1 wrote:

Thanks