Is there a way to take today's date and have it autofill another cell with a work order number? I.e., if today is 05/27/2021, I want to have the cell for the work order number read as "21-052701" if it's the first job of the day, and "21-052702" if it's the second. If only having it auto fill the first time is the only option, that's fine. It will save me time still.
