It’s 2021 and I still see people managing projects using Excel spreadsheets. Sure you CAN do it, but you can do better. I am a fan of OpenProj and I use it often. If that is not for you, consider this online version: Build Gantt Charts Online.
What I like about these tools is you can tie tasks together which have dependencies (as shown in the image). This is very helpful and something not easy to do with spreadsheets.
Speadsheets are great for many things: for managing projects, use a better tool.