Thread: =TODAY()
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default =TODAY()

Enter dates as 01/mm/yy for each month and format as mmm-yy

Or have I misunderstood?

"Steved" wrote:

Hello from Steved


=TODAY()

My issue is this I would like use the above as mmm-yy, yes I've formatted my
cell to do this and it does exactly as it is supposed to do, However I want
to do this for every month for example in Cell "A15" I've got Jun-07 but
would like to have the previous month ie May-07, then in Cell "A14" I want
Apr-07, then in Cell "A13" to Cell "A4" until I have the whole year entered
please. How would I go about this.

Thankyou.