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.