Thank you very kindly. Never knew most of this was possible. I am in your debt.
@VeronicaSanchez-qt1zf
22 күн бұрын
I watched this video yesterday, I created my first calendar yesterday. I love it. Just one question, how about if I want each item to show up on it's own line, instead of one after the other, just separated by comma?
@nassiriabraham
3 ай бұрын
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
@AudreyFlorence
3 ай бұрын
Jeff, always, thank you! I've already modified your exercises to fit a recent need at my company!
@ExcelCampus
3 ай бұрын
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
3 ай бұрын
Thanks Jon!! I agree and am still discovering ways to apply dynamic arrays :)
@millychen2596
3 ай бұрын
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?
@PaulEBrownbill
3 ай бұрын
Thanks Jeff, great as always. Paul
@zanquinoe.s.7131
3 ай бұрын
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.
@BigD63
3 ай бұрын
Great info ... Thanks Jeff
@WavzonRox39
3 ай бұрын
Excellent!
@Herostocafilmer
Күн бұрын
great calender but how would you add events with a start and end date? i want to create a year calendar that shows all the onsite days for my event staff. a month could have multiple events happening at the same time
@ExcelU
Күн бұрын
I’m releasing a video that demonstrates that this Wednesday :)
@johndurran614
3 ай бұрын
Excellent
@kimsadowski4058
3 ай бұрын
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
2 ай бұрын
The formatting applied to the cell (left/right alignment) doesn't impact the functions :) The functions operate on the stored value, regardless of formatting.
Пікірлер: 17