Display the date in a sentence with a formula in an excel report

In many occasions, in my comments, I need to put the day but in some few cases, my comment is a general one that I am using the same one every month, the only difference is the month for instance. In this case, instead to put it manually, I need it in an automatic way.

formula excel


When I use the formula ?

For any general phrases that only the date should change.


How to use the formula ?

The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".


How are the formulas ?






Put this formula in cell A1:

="The last actionwas at " & TEXT(DATE(YEAR(NOW()),MONTH(NOW()),1)-1,"dd-mmm-yyyy")

You can change “dd-mmm-yyyy” by how you want to display the date information.

Put this formula in cell A2:

="The last action was at " & TEXT(DATE(YEAR(NOW()),MONTH(NOW()),1)-1,"mmmm")

Interesting Management