Show the computer day and date when the file is opened.

[EastTexasVet]

What function will show the computer day and date in merged cells A & B when the file is opened.  What is the correct format for the function arguments. 

[#2]

u can edit data cell in more number format in home ribbon or just add 2 cell using "=consolidate" @EastTexasVet 

[#3]

@EastTexasVet What about below formula.

="Date: " & TEXT(TODAY(),"MM/DD/YYYY") & ", Day: " & TEXT(TODAY(),"DDDD")