Checking for date from "last month"...

[rickblunt]

Greetings, I have been noodling on this for a couple of days and I am at a loss as to how to solve this, or even how to phrase the question so that I can search for it on this forum

So I have a date in A1 and I just want to know if that date is from last month or not. For example, lets say this is currently October 12 - is the date entered in A1 a date from September? If it is any other date other than from September then I want to be able to create a flag that says "Missed Inspection" or something like that. The date gets updated in the same cell each month so that is why I want to be looking to see if it is "from the last month".

I am thinking that basically I just need to know if it is between the first and last day of the preceding month. I know there is a EOMONTH function but I do not know of a "First of Month" function. Does anyone have any thoughts on how I could go about doing this? I appreciate any input - thanks,

 

[Fluff]

Maybe

=if(month(a1)=month(today())-1,"Missed","Ok")

 

[rickblunt]

Maybe

=if(month(a1)=month(today())-1,"Missed","Ok")

oh of course (sound of forehead hitting desk...) because the MONTH function is looking at the month, not the days in the month (well, not directly anyway) I was too hung up on the number of the days in the month. Thanks Fluff, saved me again.

 

[Fluff]

You're welcome & thanks for the feedback.