Thread: Help make a date = Day 1 of the next month ie. 20060501, 20060601
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default 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


Reply With QuoteReply With Quote