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.

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")

Forum Discussion

Copper Contributor

Aug 27, 2022

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

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.

excel

2 Replies

Harun24HR
Bronze Contributor
Aug 27, 2022
EastTexasVet What about below formula.
="Date: " & TEXT(TODAY(),"MM/DD/YYYY") & ", Day: " & TEXT(TODAY(),"DDDD")
darshan_khona
Copper Contributor
Aug 27, 2022
u can edit data cell in more number format in home ribbon or just add 2 cell using "=consolidate" EastTexasVet