DRSteele
Well-known Member
- Joined
- Mar 31, 2015
- Messages
- 2,659
- Office Version
- 365
- Platform
- Windows
DRSteele submitted a new Excel article:
Create a Dynamic Calendar with function SEQUENCE and some formatting - Using Excel's new dynamic array formulas, we can easily generate a calendar based on a date
Read more about this Excel article...
Create a Dynamic Calendar with function SEQUENCE and some formatting - Using Excel's new dynamic array formulas, we can easily generate a calendar based on a date
Let’s create a dynamic calendar in Excel the quick and easy way. We can use the clever new Excel function SEQUENCE in Excel 365 Insider. Mr. Excel (Bill Jelen) sparked this idea with this video and I enhanced the concept so that all we need is a date to make the calendar matarialise in the spilled cells, automatically formatted with Conditional Formatting.
Format a block of 42 cells (7Cx6R), here B5 to H10, using Conditional...
Read more about this Excel article...