8 thoughts on “How to Build a Simple Three Week Rolling Schedule in Excel.

    Hernan Perez

    (December 8, 2019 - 3:05 am)

    Man get a mouse instead of a hammer… Thanks for sharing. I was expecting a column x duration but that ok

    Anthony J. Martin

    (December 8, 2019 - 3:05 am)

    So… It's a 3x nested IF formula with the middle IF using double criteria by using the AND formula.

    The first IF states:
    IF the start of the top row dates (E$1) is equal to the task start date ($C3)… Display "S"

    The second IF states:
    IF/AND The start of the top row dates (E$1) is greater than the task start date ($C3) AND less than the task finish date ($D3)… Display "Y"

    The third IF states:
    IF the start of the top row dates (E$1) is equal to the task end date($D3)… Display "F"

    You can change the S, Y & F to whatever you want, that makes sense for you. ex. Start, In Progress, Finish… etc…

    Take note of the "$". This is very important to have them in the right place so that when you copy the formula by dragging, certain values will be absolute (won't move from the column or row).

    All in all, the theory behind the video is good.

    But, in my opinion, the delivery could have been better… But that comes with practice! So keep shooting these out and keep trying to get better and no matter how hard or easy it is to watch your own videos… you should… because then you will see things that you could do better and next time, you will!

    Cheers all!

    … And i just wonder if you just could have used an IFS formula instead… That's what I would have done…

    C C

    (December 8, 2019 - 3:05 am)

    =IF(E$1=$C3;"S";IF(AND(E$1>$C3;E$1<$D3);"Y";IF(E$1=$D3;"F";""))) worked for me

    Henry Lee

    (December 8, 2019 - 3:05 am)

    I loved the schedule! Thank you so much the formula worked great! and everything else was easy to follow you were very patient for us excel novices :)) I learned a lot from you that will make my job so much efficient. Thank you so much for posting this schedule it was truly a great help.

    I did have one question and I know it would have made the formatting easier for me but I couldn't tell what the character was in the formula =IF(ES1 is the middle character an S? same with =SC3 is it an S. Or maybe post the formula. This is what I used:
    =IF(E1=C3,"S",IF(AND(E1>C3,E1<D3),"Y",IF(E1=D3,"F",""))) So I think the character I missed is what helps it copy correctly. Thanks again!

    Amirah Amilin

    (December 8, 2019 - 3:05 am)

    Tq sharing useful info .. 👌🏻👆🏻

    Jason Hosking

    (December 8, 2019 - 3:05 am)

    I cannot get the formula to work in my spreadsheet. For some reason I cannot get the "Y" or the "F" to work when I drag the formula across. Can anyone help me with this?

    jamie clarke

    (December 8, 2019 - 3:05 am)

    Too small and you do not explain the formula properly so I turned off. You said the first bit then said look elsewhere for it.

    David Hendrickson

    (December 8, 2019 - 3:05 am)

    I like it but I would like more detail on the formula you used …

Leave a Reply

Your email address will not be published. Required fields are marked *