No video
Convert a List of Events into a Graphical Calendar in Excel
Рет қаралды 7,309
Күн бұрын
@millychen2596 Ай бұрын
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 :)
@ExcelU 26 күн бұрын
The formatting applied to the cell (left/right alignment) doesn't impact the functions :) The functions operate on the stored value, regardless of formatting.
@kimsadowski4058 26 күн бұрын
@@ExcelU thank you!
Excel University
Рет қаралды 415 М.