GentlePeople,
I have a Question about How to get my "month" selection to automatically increment +1 for each new month?
I have a few different ways that I have thought it should work, but doesn't.
<tbody>
</tbody>
This is the way the month setup is currently.
What I want is for the numeric month date to increment +1 when the month become February. Or when it rolls to March I'd like for it to format the number 3.
This is what I had originally: =MONTH(LastModified()) Where it was setup with "Format only cells With: Cell Value_Equal to:
This worked for two months and then it broken somehow.
So I ignored it for a while but I'm revisiting the topic.
This is where my current thinking is: =IF(MONTH = TODAY AND ($V$2), ($V$2), Else ($V$2))
But I get a #NAME ? error.
Anyone have thoughts on how I can get this to function correctly?
Thanks.
I have a Question about How to get my "month" selection to automatically increment +1 for each new month?
I have a few different ways that I have thought it should work, but doesn't.
Circle the Month: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
<tbody>
</tbody>
This is the way the month setup is currently.
What I want is for the numeric month date to increment +1 when the month become February. Or when it rolls to March I'd like for it to format the number 3.
This is what I had originally: =MONTH(LastModified()) Where it was setup with "Format only cells With: Cell Value_Equal to:
This worked for two months and then it broken somehow.
So I ignored it for a while but I'm revisiting the topic.
This is where my current thinking is: =IF(MONTH = TODAY AND ($V$2), ($V$2), Else ($V$2))
But I get a #NAME ? error.
Anyone have thoughts on how I can get this to function correctly?
Thanks.