S
Steve
I use the following formula in a spreadsheet:
=EOMONTH(TODAY(),-1)+1
The intent is to return the first day of the current month. When I
wrote the formula, it worked fine, but the next month, the value
didn't change until I edited the cell by pressing F2, and then enter
(no change to the formula). Pressing F9 (recalc) does not fix the
result.
Is this a limitation of having the Today() function embedded in the
EOMonth function? Has anyone else had this issue? Can it be fixed?
Does anyone have a suggested work around?
=EOMONTH(TODAY(),-1)+1
The intent is to return the first day of the current month. When I
wrote the formula, it worked fine, but the next month, the value
didn't change until I edited the cell by pressing F2, and then enter
(no change to the formula). Pressing F9 (recalc) does not fix the
result.
Is this a limitation of having the Today() function embedded in the
EOMonth function? Has anyone else had this issue? Can it be fixed?
Does anyone have a suggested work around?