StargateFanFromWork said:
I have an existing spreadsheet that is just missing the year in each of the
12 cells that has a month of the year. To re-do the spreadsheet just to add
a cell for the "=today()" formatted for "yyyy" would be a horrendous amount
of work. If I could keep the text for each month but somehow add a
"today()" function, that would be great. Don't know how to do this, though.
Is it even possible?
Perhaps there is another way to add the year programmatically? I'd like to
have this spreadsheet printable at any given time of any year without having
to edit it at all. And if I had to break apart cells so that where the
current month is I'd have 2 cells, that's what I meant by a "horrendous
amount of work". There are so many individual cells underneath the months
at this time. It's not that I'm adverse to the work, per se, I don't have
time. As it stands now, no editing is needed for this spreadsheet
whatsoever. All affected dates show the current year at the time of
printout except where the months are as there are no years showing by each
date, which would be a bonus. Was hoping there was something that could be
done so that we have something like this:
"January" + =today()
where "January" means each month typed in and the "=today()" formula
represents the year? Whatever. I don't know. All of you here are the
experts, not me, so hoping there's a way. <g> Every time I ask a question
here and go through all this headache, I make my group's life easier by a
lot, so it's worth it to me to make it as easy as possible for them. I'm
not the techie in the group and this is not my job, but I know what it is to
do more work than is needed when a simple system solution eradicates the
problem to begin with! <g> This would do that. No one need ever edit
this, just edit the main data and the form prints out with all the current
dates! Awesome if we can do this.
Tx much!
D