January JA
February FE
March MR
April AL
May MA
June JN
July JL
August AU
September SE
October OC
November NO
December DE



In cell A1 is today's date plus 180 days (2009 May 25)which is like this:
=A2=180

In cell A2 is today's date in julian code (330) which is like this:
=TEXT((TODAY()-DATEVALUE("1/1/"&TEXT(TODAY(),"YY"))+1),"000")

I need the A1 cell to read 2009 MA 25

Hope this helps
Thanks,
Cindy
--
Cindy T


"Rick Rothstein" wrote:

Can you tell us what your customer's month codes for each month are? Also,
showing us your formula would be useful too.

--
Rick (MVP - Excel)


"Cindy at PWIC" wrote in message
...
I am putting in the date as a formula and adding 180 days to calculate a
best
before date but my customer has changed their date codes from Apr to AR
and I
don't know how to change my dates as excell will not recognize AR as a
date.
I thought I could change it by saying replace any Apr to AR but I want it
to
do it automatically as I this changes every month and I use this form
every
day. Thanks. Not sure if this answers your question.
--
Cindy T


"Cindy at PWIC" wrote:

I need to change date abbreviations in a formula to match customer's
dates
ie: Apr 06 change to AL 06, can this be done?
--
Cindy T