A common subject, I've found <g. I've just spent 40 mins. in the
archives and have learned a lot, but nothing addresses this issue as
my needs are much simpler than the average post. Without the analysis
tookpak and the EOMONTH, is there a way to have cells return the last
day of the month based on the preceding column's month/year?

The trick is that I would like to input just the year in question once
at the top, say in cell A1 and for Excel to populate the 12 months in
the 12 cells below.

I tried doing this in column A underneath, for example:
=A$1 & " - January"
=A$1 & " - February"
=A$1 & " - March"
down to December,

but realized that although this displays perfectly in cells A2 down,
it probably won't be good for the calculation in column B.

So all that's needed is to have a display of each month in column A,
the year being determined by A1 in a way similar in intent to above;
while in column B starting at B2, the formula would return
Tues.Jan.31.2006 for the month of January 2006, Tues.Feb.28.2006,
etc., etc., down the column changing when a different year is put in
A1.

There are many financial transactions that give interest on the last
day of the month (vs. last weekday) and that also pull fees on the
last day. Every time I'm recording this info. I have to pull up the
calendar in the systray where a simple spreadsheet with this info
could be posted above computer station.

Thank you! :oD