Date Management

[Nigel]

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

 

[Niek Otten]

=MONTH(DATE(YEAR(A1),MONTH(A1)-1,1))

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

Assuming the date you want to use is in A1, =IF(MONTH(A1)=1,12,MONTH(A1)-1)
will do the trick.

 

[Ron Rosenfeld]

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

 

[Nigel]

Thanks for the replies

--
Cheers
Nigel

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

=MONTH(A1-DAY(A1))

should do it.


--ron