Thread: Date Management
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
  
Posts: 923
Default Date Management
Hi All
What is the simplest way to determine from a DATE the prior month number?

eg Using European Date format
1/03/2005 would give 2 as the prior month
10/01/2005 would give 12


--
Cheers
Nigel




Reply With QuoteReply With Quote