A formula field calculation knows nothing about the context of where the entity is being viewed, or by whom the entity is being viewed, so this is fundamentally not possible.
The result of a formula field is always the same for all people*, no matter the ‘context’ of the entity.
*minor exception is that formulas that result in a datetime value will be localised to the user’s timezone
It could be that you might need something like this: