Thread: How do I show the current month in a date field?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
  
Posts: 410
Default How do I show the current month in a date field?
On May 22, 1:04*am, G-man wrote:
I wish to set an automatic update for the MONTH in a date column in a monthly
expense worksheet, so those date fields will change each time I open the
worksheet. Is there a way to do this in Excel 2007?

Could you use the =Today() Function in that cell and then right click/
format/custom mmmm?
Jay
Reply With QuoteReply With Quote