Automatically insert todays date as a month?

How can i enter todays date as a month?

Is is my formula which I am pinching from a previous spreadsheet which gives me the da, month and year but I want to just show the month as the written word.

="PROPERTIES ON SITE AS OF "&TEXT(TODAY(),"dd/mm/yyyy")

You can change the "dd/mm/yyyy" part of the TEXT function to dictate how the date is shown, for just the [full] month in text change to "mmmm", i.e.

="PROPERTIES ON SITE AS OF "&TEXT(TODAY(),"mmmm")

Hi,

Please Login or Register  to view this content.

HTH