Cell to return present month

[joromajr]

-- How can I make a cell return present month and remain as such.

Ex. present month is July... A1 will return "July" will have data encoded
in b1. But when august comes it will not change anymore?
joromajr

 

[Peo Sjoblom]

Press ctrl + ;

then format as mmmm

Or use

=TEXT(TODAY(),"mmmm")

then copy and paste special as values in place preferably before 08/01/08
<g>

--


Regards,


Peo Sjoblom

 

[joromajr]

-- Thank you for the quick response, but situation call for a more
permanent solution as the file will be distributed to 72 offices whose
locations are mostly overseas.

Please help need more suggestions.

joromajr

 

[Wigi]

Why shouldn't it work anymore, then?

 

[joromajr]

-- Because it will serve as account database for transactions of particular
month.
joromajr

 

[MyVeryOwnSelf]

-- How can I make a cell return present month and remain as such.

Here's one way.

In Tools > Options > Calculation
Check the "Iteration" box
Set "Maximum iterations" to 1

In A2 put
=A2+1

In A1 put
=IF(A2=3,TEXT(TODAY(),"Mmmm"),A1)

Save the file.

Make several copies of the saved file for later use.

The first time one of the copies is opened, A1 should contain the present
month, and it shouldn't change as long as nobody overwrites A1 or A2.

Modify to suit.