Today() display based on country

[Zubair]

Hi all,

Suppose I am in Dubai, time is 9 am 16/12/2021 and applying today() formula in excel file and sending it to my co-worker in USA.

Which date will appear USA or Dubai when my co-worker open it at the same time?

 

[Fluff]

Today will always return the date based on the system date on that computer.

 

[Joe4]

I believe it will use the regional settings that are set on that co-worker's computer.

 

[etaf]

i believe TODAY() uses the date and time on the PC

5 Ways to Get the Current Date or Time in Excel | How To Excel

www.howtoexcel.org

It will return the current date based on the user’s PC settings.

This means if we include this function in a workbook and send it to someone else in a different time zone, their results could be different.

 

[Zubair]

Many thanks for your quick answers.
@Fluff, @Joe4 & @etaf

 

[Fluff]

Glad we could help & thanks for the feedback.