More Excel love. I was working on a report a couple of weeks ago, and knew it was possible to have multiple lines of text in a cell, but didn't know how to do it. I know that with some HTML editors (e.g. Nvu) you can hold Shift ...
This is old news by some measure, but it is a timeless piece of trickery with Excel.
Make a calendar in Excel:
=IF(MONTH(DATE(YEAR(NOW()),MONTH(NOW()),1))
<>MONTH(DATE(YEAR(NOW()),MONTH(NOW()),1)-
(WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW()),1))-1)+
{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),"",DATE(YEAR(NOW()),
MONTH(NOW()),1)-(WEEKDAY(DATE(YEAR(NOW()),
MONTH(NOW()),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)
To use it:
Copy the formula text to the clipboard
Activate an Excel sheet and select a 7-col by 6-row range
Press F2
Press Ctrl+V to paste the formula into the active cell
Press ...
I used to work for a financial analysis company developing Excel macros/applications in VBA. There were -- and still are -- some 10th level Excel blackbelts that work there. I picked up quite a few keystroke tricks while working there. Even though I don't work there anymore, ...
