ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Date Functions (https://www.excelbanter.com/excel-discussion-misc-queries/136222-date-functions.html)

[email protected]

Date Functions
 
I would like to have a spreadsheet setup to return the MONTH automatic
in a given CELL. i.e. in cell a20 I want the name of the month to be
returned in increments every time I open the worksheet.

For example January, February and so on, and have it to change
(update) automatic on the monthly basis every time I open it.

Is that possible?

Thanks,

Gaspar Silva


Max

Date Functions
 
In A20: =TEXT(TODAY(),"mmmm")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
ups.com...
I would like to have a spreadsheet setup to return the MONTH automatic
in a given CELL. i.e. in cell a20 I want the name of the month to be
returned in increments every time I open the worksheet.

For example January, February and so on, and have it to change
(update) automatic on the monthly basis every time I open it.

Is that possible?

Thanks,

Gaspar Silva





All times are GMT +1. The time now is 03:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com