>>>All the more reason to have it, IMO. What do you think this means: GOMONTH(DATE() - DAY(DATE()) + 1, 1) - 1
>>>
>>>A rose by any other name would smell as sweet, but having to decipher a formula stinks.
>>>
>>
>>It means last day of this month. What is there to decipher it? To decipher you need something like a cipher, no? Maybe I don't see the philosophy here:) IMHO that X2... was something to decipher for a simple task that you could do inline.
>>Cetin
>
>I'm surprised you do not see the problem. GetLastDayOfMonth() needs no deciphering/decoding/thought. If you have never seen the above line, you cannot tell what it does as quickly as GetLastDayOfMonth().
No I don't see the problem. I can easily say at a glance that code is for finding last day of this month while GetLastDayOfMonth() is not as clear and needs deciphering. Does that accept parameter and used for any month or this month?
In case of X2... isn't it the same? You would use such a thing very rarely and probably each time you use you would need to check source to remember what it does. An inline code OTOH would be short, clear, concise (for me).
Cetin