Forum Discussion
Automatically converting MO/00/YR to the last day of the month
Hi, I work in a lab where we use excel 365 to document out quality control. Some of the reagents we use have the expiration as MO/year. I want to know if there is a way for us to put MO/00/yr and...
Not anymore?
I tried figuring out how to do multiple columns using that code by myself but I can't get it. So in this scenario we have multiple reagents in the same worksheet that have an expiration date with the 12/00/21 format. Can I do that? Thanks,