Currently if you have server in one timezone and end user in different timezone then in a cell =now() returns server date/time. Now function should consider what timezone end user is and show date/time related to end user.