Thread: Date Functions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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