Re: Showing first day of the next month in a column ...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"JE McGimpsey" <jemcgimpsey@xxxxxxxx> wrote in message
news:jemcgimpsey-D69FFF.09012529052007@xxxxxxxxxxxxxxxxxxxxxxx
Both should work fine.

The first always refers to the date in B2, then creates an offset based
on the row that the formula is in. The second creates a relative
reference to the cell above.

Oh, yes. I should have mentioned that I understood re the absolute
references in $ symbol. Thanks for figuring out that I meant the
differences in the formula itself and not that part <vbg>.

The main advantage of the second formula is it's a bit more efficient -
one less function call (don't waste the millisecond or two by
blinking...). A second advantage is that it's slightly easier to

<lol>

interpret, making it perhaps easier to maintain.

A possible advantage of the first formula is that if you insert a blank
row, the formulas below that row will continue to calculate months based
on B2 (though with a skipped month). This could also be a disadvantage,
depending on your application (i.e., giving a possibly erroneous date
that looks reasonable)

None are especially compelling reasons to pick one over the other, but
my sense of aesthetics would pick the 2nd.

Ah, good enough for me. I may make decisions based on that, too, along with
the consideration of the elegancy of some code over another when they do
pretty much the same thing.

Thanks! :oD

In article <uqgFvtfoHHA.4032@xxxxxxxxxxxxxxxxxxxx>,
"StargateFanFromWork" <NoSpam@xxxxxxxxxx> wrote:

Is there any advantage in using one formula over the other? i.e.,


B3: =DATE(YEAR($B$2),MONTH($B$2)+ROWS($1:1),1)
vs.
B3: =DATE(YEAR(B2),MONTH(B2)+1,1)

I tried the =DATE(YEAR(B2),MONTH(B2)+1,1) and that works but was
wondering
about the first formula.


.

Relevant Pages

  • Changing default output object for
    ... reasons why it is a bad idea or not possible, but, is there any ... with combination of byte codes which inserted in a reference to ... Python code snippets and compile to byte code. ... registered response object, but instead of doing it this way, could ...
    (comp.lang.python)
  • Re: Ban snaring in Scotland
    ... survey, the first thing you should ask for is the reference which shows ... reference, fails to produce it. ... my post do I refer to SIX reasons. ... A bird was flying south for the Winter. ...
    (uk.environment.conservation)
  • Re: Nazi Medical Research
    ... "Sensou", a reference I have offered over the years? ... about Japan's side of the war from the Japanese side. ... you were given numerous reasons your inquiry as to why Mengele ...
    (soc.history.war.world-war-ii)
  • Re: Ban snaring in Scotland
    ... If BASC recognise it is cruel, ... survey, the first thing you should ask for is the reference which shows ... reference, fails to produce it. ... my post do I refer to SIX reasons. ...
    (uk.environment.conservation)
  • Re: Ban snaring in Scotland
    ... If BASC recognise it is cruel, ... survey, the first thing you should ask for is the reference which shows ... reference, fails to produce it. ... my post do I refer to SIX reasons. ...
    (uk.environment.conservation)