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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help make a date = Day 1 of the next month ie. 20060501, 20060601 (https://www.excelbanter.com/excel-worksheet-functions/81929-re-help-make-date-%3D-day-1-next-month-ie-20060501-20060601-a.html)

Niek Otten

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

For A10, read A1

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message news:...
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

All times are GMT +1. The time now is 03:47 AM.