Forum Discussion
Sharon_Dquest1
Mar 11, 2021Copper Contributor
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...
HansVogelaar
Mar 11, 2021MVP
Not anymore?
Sharon_Dquest1
Mar 17, 2021Copper Contributor
I was having to change some the sheets because some them have the expiration column in D instead of E. I'm not sure what I was doing wrong but now it is working. Thanks for the help! HansVogelaar