Thanks Sam,
I left out one little fact. This is for VBA. I tried the code in my
module, but it got confused. In some cases ws code and vba are similar,
but for DATE function, they are very different! I am sure there is a
functional equivalent. I am also posting the VBA I've written thus far
In fact you probably don't need that - 1. Remove it. I'm just typing this
on my handset, so please don't mind.
On Aug 8, 2013 6:50 AM, "Sam Mathai Chacko" wrote:
> Don, try passing the number of days to the date function like this.
>
> =TEXT(DATE(2013,1,No. Of Days - 1), "m\/d")
>
> Sam MATHAI CH
Don, try passing the number of days to the date function like this.
=TEXT(DATE(2013,1,No. Of Days - 1), "m\/d")
Sam MATHAI CHACKO
On Aug 8, 2013 4:11 AM, "Don Barton" wrote:
> Greetings,
> I work at a hospital laboratory and we have an expiration date barcode on
> blood transfusion units that f
Greetings,
I work at a hospital laboratory and we have an expiration date barcode on
blood transfusion units that formats the month and day as a number; the
number of days since the beginning of the year. We use a barcode scanner
to read in the expiration date, but need to convert the number o