barcelona

more panorama pictures

excel

1 click excel macro tool

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 ?

=TEXT()

=DATE()

=YEAR()

=MONTH()

=NOW()

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