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

N

Niek Otten

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)
 
J

JE McGimpsey

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),"yyyymmdd")
 
J

JS1

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


JE McGimpsey said:
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),"yyyymmdd")
Click to expand...
 
Top