Is it possible to show the length of the programs? For instance, I have programs that run 4 weeks or 8 weeks or 12 weeks and they all have different start dates. Is there a way to display what programs are running everyday?
Great video Jeff! I remember creating something similar for a scheduling calendar before dynamic array formulas were released. It was so much more difficult to do back then. Dynamic arrays make life easy. 😊
Thank you for all the content. Any tips regarding fixing the “Formula Bar” font changing when displaying a formula? For example, when you click the CELL the formula bar presents a FONT but when you press the formula bar to make changes the FONT changes making me double click the bar to reposition.
The formatting applied to the cell (left/right alignment) doesn't impact the functions :) The functions operate on the stored value, regardless of formatting.