Juilenne codes

  • Thread starter Thread starter Mark \(InWales\)
  • Start date Start date
M

Mark \(InWales\)

Anyone had any luck working out julienne codes either by entering the day or
date? I am stuck on returing a date that is higher than todays, last years
production - any ideas? For instance today = 291 so anything less than
today will be produced 2004 but if higher than today i.e. 292 for tommorrow
I want to return 2003...

Hopefully
Mark(InWales)
 
Show us what you are doing so we can give more useful reply to Julian
question
(Julienne is a way of cutting carrots!)

best wishes
 
Bernard

That's probably why I'm not finding much help at google - LOL!

Okay then, sheet one contains the formula =today() in A1 so my code in B1
looks something like this:
=lookup(a1,Dates,Day) which returns the "JULIAN!" code of 291. So far so
good.

When I enter the julian day code from a batch number if it is greater than
today then the year of manufacture should be returned as year 2003 so using
day code 292 I want to return 18/10/2003. So once again with the input cell
as A1,
=lookup(a1,day,dates).
Day = 1 - 365 (leap year taken into account)
Dates = 01/01/2003 - 31/12/2005

Does this make sense?
Thanks for the reply
Mark(InWales)
 
Bernard - don't worry about replying further as your help has been
invaluable already in supplying the correct spelling. Currently scanning
the knowledge base - I seem to have everything wrong!!!

Thank you
 
I'm not quite sure how you do your data entry, but if you use A1, then I think
this formula will work:

=IF(DATE(YEAR(TODAY()),1,A1)>TODAY(),
DATE(YEAR(TODAY())-1,1,A1)-(MONTH(DATE(YEAR(TODAY()),2,29))=2),
DATE(YEAR(TODAY()),1,A1))

(all one cell.)

That extra stuff is to check to see if the current year is a leap year.

It seemed to work ok for me. But you should test it some more.
 
Back
Top