Here are some pro tips for using the DATE function in Excel to express the current date instead of a static figure. Quick Excel Help. Be sure to set the formula calculation options to automatic. Instant Connection to an Expert through our Excelchat Service: Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you.