DATE() Month in Letter NOT Number

  • Thread starter Thread starter Neon520
  • Start date Start date
Each to his own, then.

I noted you did not caution about the DATEDIF inconsistencies in a previous
thread, nor mention concern about it's use when it is not documented; so I
guess there are only certain undocumented features that concern you.

I'd have a lot more concern about using MOD with certain classes of numbers
(also undocumented), or using DATEDIF, than I would about date_text
conversions.
--ron



Indeed. Anything that is undocumented, is subject to change, removal etc. MS
has no obligation to support such things.

Tyro
Click to expand...

--ron
 
=--(A2&" "&A1&" "&A3)
That is interesting. I never realized that NO separators could be used,
Click to expand...

I'm not sure why, but when I saw Dave's DATEVALUE formula, it reminded me of
the date format that was used on my orders from my days in the Air Force...
I always thought 15Jan08 was a nice format for some reason (although it
"looked" better when the year wasn't decipherable as a day value; e.g.,
15Jan67), so it occurred to me to try it in the DATEVALUE function... and it
worked. Then I saw your --(<datestring>) format and figured I would try it
there too... and, again, it worked.

Rick
 
I'm not sure why, but when I saw Dave's DATEVALUE formula, it reminded me of
the date format that was used on my orders from my days in the Air Force...
I always thought 15Jan08 was a nice format for some reason (although it
"looked" better when the year wasn't decipherable as a day value; e.g.,
15Jan67), so it occurred to me to try it in the DATEVALUE function... and it
worked. Then I saw your --(<datestring>) format and figured I would try it
there too... and, again, it worked.

Rick
Click to expand...

I remember that format, now that you mention it. And I, too, was dealing with
years that could not be mistaken for day (or month) values <g>.
--ron
 
Back
Top