Need of Date Series without sundays

[Santhoshgrm4]

Hi,

Can someone help me with this?

In dates column date series should automatically change, as in Places columns every trip ends in Bangalore and next trip commences from Bangalore to next place should be next day, this needs to be automatically converted considering only working days (Sunday should be excluded).

Thank you,

Places	Travel from and to	Date
Bangalore	Uttar pradesh to Bangalore	31-Jan-2023​
Mumbai	Bangalore to Mumbai	01-Feb-2023​
New Delhi	Mumbai to New Delhi	01-Feb-2023​
Chennai	New Delhi to Chennai	01-Feb-2023​
Kolkata	Chennai to Kolkota	01-Feb-2023​
Bangalore	Kolkota to Bangalore	01-Feb-2023​
Orissa	Bangalore to Orissa	02-Feb-2023​
Gujarat	Orissa to Gujarat	02-Feb-2023​
Rajasthan	Gujarat to Rajasthan	02-Feb-2023​
Bangalore	Rajasthan to Bangalore	02-Feb-2023​
Goa	Bangalore to Goa	03-Feb-2023​
Kerala	Goa to Kerala	03-Feb-2023​

 

[bebo021999]

Book1
	C
1
2	31-Jan
3	01-Feb
4	02-Feb
5	03-Feb
6	04-Feb
7	06-Feb
8	07-Feb
Sheet2

Cell Formulas
Range	Formula
C3:C8	C3	=WORKDAY.INTL(C2,1,11)

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C
1	Places	Travel from and to	Date
2	Bangalore	Uttar pradesh to Bangalore	31/01/2023
3	Mumbai	Bangalore to Mumbai	01/02/2023
4	New Delhi	Mumbai to New Delhi	01/02/2023
5	Chennai	New Delhi to Chennai	01/02/2023
6	Kolkata	Chennai to Kolkota	01/02/2023
7	Bangalore	Kolkota to Bangalore	01/02/2023
8	Orissa	Bangalore to Orissa	02/02/2023
9	Gujarat	Orissa to Gujarat	02/02/2023
10	Rajasthan	Gujarat to Rajasthan	02/02/2023
11	Bangalore	Rajasthan to Bangalore	02/02/2023
12	Goa	Bangalore to Goa	03/02/2023
13	Kerala	Goa to Kerala	03/02/2023
Main

Cell Formulas
Range	Formula
C3:C13	C3	=IF(A2="Bangalore",WORKDAY.INTL(C2,1,11),C2)