Cell to return present month
 

-- 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

Cell to return present month
 

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" wrote in message
...

-- 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

Cell to return present month
 

-- 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


"Peo Sjoblom" wrote:

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" wrote in message
...

-- 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

Cell to return present month
 

Why shouldn't it work anymore, then?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"joromajr" wrote:


-- 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


"Peo Sjoblom" wrote:

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" wrote in message
...

-- 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

Cell to return present month
 

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


"Wigi" wrote:

Why shouldn't it work anymore, then?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"joromajr" wrote:


-- 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


"Peo Sjoblom" wrote:

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" wrote in message
...

-- 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

Cell to return present month
 

-- 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.