Thread: Convert date to number representing Month
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karin Karin is offline
external usenet poster
  
Posts: 125
Default Convert date to number representing Month
Hi,
If I have a date [NOW()] in Cell A1, I want to put a number representing the
month in A2 (for July, the number would be 7). This is so I can multiple by
the quantity of months. How can I accomplish that?
Reply With QuoteReply With Quote