Articles tagged with: worksheet
Excel Daily Calendar with Tasks and Notes
I finally made a pretty cool daily calendar (just like those daily sheets in your planner/organizer). I recently trashed my old organizer which lasted me 12 years and I had to somehow mourn my loss.
Instructions:
Change …
Excel Calendar
Here’s a complete calendar in Excel using the following formula.
=IF(MONTH(DATE(YEAR(A1),MONTH(A1),1))<>MONTH(DATE(YEAR(A1),MONTH(A1),1)-
(WEEKDAY(DATE(YEAR(A1),MONTH(A1),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),””,
DATE(YEAR(A1),MONTH(A1),1)-(WEEKDAY(DATE(YEAR(A1),MONTH(A1),1))-1)+{0;1;2;3;4;5}*7
+{1,2,3,4,5,6,7}-1)
This is the first edition. Each month is on a separate worksheet. After revisiting this, I forgot how to do arrays in Excel. Follow theses steps …
