Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
-- 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I add present month, as number, to an header in excel? | Excel Discussion (Misc queries) | |||
Need cell formulas to return the day of every Monday in a month based on year entered | Excel Discussion (Misc queries) | |||
calculating month of present date | Excel Discussion (Misc queries) | |||
Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
Return 1st of the Month | Excel Worksheet Functions |