Roddenberry’s memo about stardates being the episode producer’s birthday multiplied by the ship’s distance from Earth was a joke.
However even when you order the episode by production date the stardates still don’t line up. Even in season three where the episodes were aired in production order, the stardates still bounce around a bit.