![]() Finally, I formatted the calendars nicely.Then, I used the same in individual calendar worksheets along with INDEX formulas to fetch the dates.Once the mini calendar is ready, I just created 12 named ranges m1_, m2_,…, m12_ corresponding to each of the 12 months.This formula is mapped to named range – calendar. For given month, the calendar is nothing but =daysAndWks + DateOfFirst - WEEKDAY(DateOfFirst,2).This formula is mapped to named range – DateOfFirst Next step is to find the first date of each month using a simple date formula like =date(year,month,1). ![]() I mapped this formula to daysAndWks named range. I used a combination of INDIRECT, OFFSET and COLUMN to get this.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |