View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

if you'ld like to direct a request to microsoft then you'll need to email
them at

with Excel in the subject line.

this is a user based peer-peer discussion group providing assistance and
information on specific requests regarding excel. However, if you're post
was a request asking how comments can be included in formulas then this can
be achieved as per the following example:

=(EOMONTH(TODAY(),0)-EOMONTH(TODAY(),-1)) +N("number of days in the current
month.")

Regards
JulieD

"Mantvydas" wrote in message
...
Sometimes in worksheets the formulas can get out of hand, and when you
open a
file a while after you last touched it, you can no longer understand some
formulas you have in your worksheets.

Can you please include syntax for cell function parser, so that it is
possible to add any comment text after the last bracket and it'd just
ignore
it. You can even have an apostrophe like in VB to avoid inveting a wheel.

Say, such a formula including comment could be valid in a cell:
=(EOMONTH(TODAY(),0)-EOMONTH(TODAY(),-1)) 'counts number of days in a
current month.