How to get next workday date when format is yyyymmdd without helper column

[andycreber]

How to get next workday date when format is yyyymmdd without helper column

Cell A1 = 20240205

Cell A2 wanting formula from data in A1 to be next working day

many thanks

 

[Georgiboy]

Maybe this will help:

Book1
	A	B
1	Format only	New date
2	20240205	06/02/2024
3
4	Just numbers
5	20240205	06/02/2024
Sheet1

Cell Formulas
Range	Formula
B2	B2	=A2+1
B5	B5	=DATE(LEFT(A5,4),MID(A5,5,2),RIGHT(A5,2))+1

 

[MARK858]

Try something like the below (please note I have used 20240209 to show what happens with a weekend). There is also an option to add in a list of holidays

Book1
	A	B
1	20240205	20240206
2	20240209	20240212
Sheet2

Cell Formulas
Range	Formula
B1:B2	B1	=WORKDAY(TEXT(A1,"0000-00-00")+0,1)

Cells in column B are formatted as yyyymmdd and assumes column A are just numbers and not a real date formatted as yyyymmdd

 

[Georgiboy]

Sorry, my bad, I missed the workday part. I clearly need a coffee.