On Fri, 11 Mar 2005 13:41:18 -0000, "Nigel"
wrote:

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

With the date in A1 (as an Excel date; the format is irrelevant):

=MONTH(A1-DAY(A1))

should do it.


--ron