How to Make a Cell on Microsoft Excel With a Changing Date. Microsoft Excel offers a Function Library with formulas that insert the current date when you open the worksheet or enter calculations.

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.