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

New Contributor

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 Replies

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

@EastTexasVet What about below formula.

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