How To Create A Glide Path In Excel

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

Bernie Deitrick

I will assume that the cells with "LAST DAY OFF" is cell B2 - adjust accordingly if it is not. I have also assumed the day numbers in row 2 are actual dates formatted to show just the day. If they are not, then they should be converted to dates.

In cell C3, enter the formula

=C$2-$B3

and copy down and across to match your header and row labels. Apply conditional formatting to get your color bands. If there is a limit to the numbers you want displayed, change the formula to, for example:

=IF(C$2-$B3<29,C$2-$B3,"")

HTH,
Bernie

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

since obviously know what I'm up too I will re send a better pick. This for tracking resources that are assigned to fires in California. some can only work a 14 day shift others are 21 days the can work their last day (LWD) the have to leave the last the ones that are 24 can R and R and come back. Need to put a calendar date in to start the cycle than have it go from there. Here is a better Pic

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Bernie Deitrick

Try this file

https://1drv.ms/x/s!AsKdy7Nfg_FbgwnziluyNLfiV3Va

HTH,
Bernie

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Bernie This is perfect can yo make me one for the 14 day

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Bernie Deitrick

Not sure how you wanted to shade the cells, so I just took off the red.

https://1drv.ms/x/s!AsKdy7Nfg_FbgwplOqkV9_2i5OXN

HTH,
Bernie

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

can I run both formulas on the same sheet or do they have to on a separate sheet in the work book

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Bernie the formula in the !4 day is not calculating when you change the date

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

ok found the problem when tried to move the formula to the excel file I had the formula didn't work how do I make this file as me the owner so I can share it

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Bernie Deitrick

Here is a file where the schedules are on one sheet - and an extra column to show if the crew is a 14 or 21 day crew.

https://1drv.ms/x/s!AsKdy7Nfg_FbgwscKMfp4dy2LtwK

Just download the file and you become its owner - there are no restrictions on editing the file once you have downloaded it.

HTH,
Bernie

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

OK Bernie you have been amazing and we really appreciate your help with this one last format change and we are good to go please center the numbers in the format and make the 14 day plan look like below thanks again so much.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.