Excel 2007 : Determine 2 months prior from a date

[localhost]

Hi all,

I've been trying to determine 2 months prior from a date in a cell entry but have been unsuccessful. Here's what I'm trying to achieve:

I've got 10 Nov 09 in cell A1. I want it to determine if the date is between (Sep to Nov 09) and display a message ("Item Due") if it matches correctly. It should be able to match the month even if the date is < 31.

Thanks!

[shoukat8]

Hi,

Is there any website for getting trained on Macros 2007 for free?


Thanks,
Shoukat

[teylyn]

shoukat, welcome to the forum. Please take a look at the forum rules and then start your own thread.


Localhost, what ranges are you comparing A1 with? In any case, you can use the Edate() function to subtract or add months and arrive at the correct date.

For example A1 = 31-Mar-2010 then =EDATE(A1,-1) will return 28-Feb-2010.