Aug 26 2022 07:47 PM
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.
Aug 26 2022 08:07 PM
u can edit data cell in more number format in home ribbon or just add 2 cell using "=consolidate" @EastTexasVet
Aug 26 2022 09:09 PM
@EastTexasVet What about below formula.
="Date: " & TEXT(TODAY(),"MM/DD/YYYY") & ", Day: " & TEXT(TODAY(),"DDDD")