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?
@nassiriabrahamАй бұрын
This is indeed advanced concept but the way you make it look easy is also another level for me Thanks for sharing this tips and tricks
@ExcelCampusАй бұрын
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. 😊
@ExcelUАй бұрын
Thanks Jon!! I agree and am still discovering ways to apply dynamic arrays :)
@AudreyFlorenceАй бұрын
Jeff, always, thank you! I've already modified your exercises to fit a recent need at my company!
@PaulEBrownbillАй бұрын
Thanks Jeff, great as always. Paul
@BigD63Ай бұрын
Great info ... Thanks Jeff
@zanquinoe.s.7131Ай бұрын
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.
@user-mb9mo8ku8wАй бұрын
Excellent!
@johndurran614Ай бұрын
Excellent
@kimsadowski4058Ай бұрын
Hi Jeff. Does it matter whether the date is to the left or to the right of the cell with the WEEKDAY of the EOM functions? Many thanks :)
@ExcelU26 күн бұрын
The formatting applied to the cell (left/right alignment) doesn't impact the functions :) The functions operate on the stored value, regardless of formatting.