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...
Sharon_Dquest1 although HansVogelaar gave you a nice macro why not just do it in the sheet? I'm going to assume in some cases you have MM/DD/YYYY expirations (middle of the month) and can't apply a EOMONTH() to the dates and that is why you are entering MM/00/YYYY. But if you have to train someone to always do that, why not just train them to enter MM+1/YYYY? If your quality system says a reagent that expired 04/2021 is good through the month of 04/2021 then just enter 05/2021 into your system. Either way you have to train the person entering the data and you will have human error in either case.