Populate Initial Time with airSlate SignNow

Establish mark template

[Music] hello everyone and welcome to the Excel challenge if you want to learn how to create a quick and simple timeline that you can use in Excel and you can adjust your task iterations and your start date and end date and that sort of stuff please stay tuned okay the first thing I'm going to do is fill some general information for project three green project duration project start date and project and be the name of the break is going to be kitchen renovation I do top now at this point the duration of the prayer I do know we want to start on May 1st 2017 just a so formatting here the next thing I want to do is start plumbing my timeline here so I'm gonna enter a task ID a task description a task duration start date and an end date for this example I'm going to use a total of 10 tasks and let's use some borders here now I can start entering the tasks for the project so a first task is going to be demolition which is going to take four days to complete the next task is very install new tiles which is going to take two days and flying now delivering the customer it's gonna take a day the start date for my first task is gonna be made first like we said before now the end date should be equals to the start date plus the duration of the task in this case the Malaysian is going to last for days therefore the end date is gonna be May 5th for this project I'm going to assume that I can only start a new task a day after I finish the previous task that being said the start date for new tiles should be equals the end date for demolition plus one day therefore May 6th to get the end date of new tiles I'm going to use the same formula that I used above and I'm gonna fill down by using control D so the end date for install new tiles its May 8th since it's gonna take two days to complete the task I'm going to fill down this formulas all the way to my final task I can see here my starter is made first and my end date is May 28th now that I have the list of tasks the duration of each and the start and end date for each the next thing I want to do is that timeline next to my first table I'm gonna start with my start date which is May 1st I don't wanna come to be this wide so I'm gonna choose a vertical alignment ninety degrees and do some formatting and then I'm gonna draw this column till the end of the month I now have May first until May 31st the last thing I'm going to do here is the calculations let's start with project duration in order to calculate the project duration I need the project start date and the project end date I'm gonna delete this value here my sterday will be the minimum value in the start date wrench enter my end date is gonna be the maximum value in my end date wrench enter the pre iteration is going to be the difference of the two end date - start date enter my project duration is going to be 27 days next thing I wanna do is compare each column to the start and end date of each task I wanna start with me first I want to compare May first and see if it's between the start date and the end date for that I'm going to use the if formula and within if I'm gonna have a logical test that includes the end formula which has two portions number one is May first greater than or equals to my start date does the first half comma and is May first less than or equals to my end date close parenthesis if these two are true I want Excel to drop an X in here if it's not true I wanted like so I'm gonna use quotation mark edition mark close parenthesis and enter and yes in fact may first falls between my start date and mandate since I'm going to be copying this formula to the right I wanna lock my column D and I want to lock my column E and since I'm gonna be dragging this formula down I wanna lock my row 5 and my row 5 enter when I copy this formula down and to the right Excel does the trick so now I have a timeline the last thing I'd want to do is change this XS for a nice formatting so what I'm going to do is select this range I'm gonna use some conditional formatting where I'm gonna say if the cells are equal to X I wanna have a green fill and I'm gonna pick the same font color so I don't see an X but instead a green square now I have a time line so now I can play with the date in my project for example let's say my tiles are delayed and instead of taking 2 days it's actually gonna take 4 days let's see what happens to the timeline oh the whole thing got delayed now my prey duration is 29 days and my parade end date is 31 days and let's say that installing new cabinetry snuck away three days is only gonna be one day let's see what happens to the timeline it'll just automatically time for the bonus trick let's say your project is delayed by two months so your new start date is no longer May 1st but July 1st let's see what happens to the timeline oops we lost it main reason is because on the top we have the amount of main in order to fix this we're going to say this start date is always going to equal my start date in this cell the value in this cell is always going to be equals my start date plus one day and I'm going to copy this formula to the right by filling it with ctrl R my time line is back regardless of the start date so let's say my new date is actually Todd was first the dates on the top changed as well let's try one more time let's say my new start date is October the first when I hit enter the dates on the top change to the month of October my new project start date is October the first my new project end date is October 28th my project duration is 27 days and I can continue playing with the timeline that way I want so let's say 5 3 3 any updates automatically that's it for today if you have a chance that you can help with whether it's at work at home or at school don't forget to put in the comments below I try to resolve the most common challenges of our viewers and subscribers thanks for watching and I'll see you in our next video