How to use the IF & DATE functions together to flag a column???

[jgomez]

Hi there I’m not sure of how to go about this…

I’d like to add a flag on column D that states Month End Hit if the date is before September on column C. If the date on column C is in September I’d like to no value returned…

I think an IF function will do well but I’m not too familiar of using the date functions…

[Dulanic]

Copy this down starting at D3.

=IF(MONTH($C3)=9,"",IF($C3<DATE(2011,9,1),"Month End Hit"))

[jgomez]

it works but why did you write =9? is it because of September??? Sam question for the date???

this formula would have to be updated each month then???

[Dulanic]

it works but why did you write =9? is it because of September??? Sam question for the date???

this formula would have to be updated each month then???

Yes, I wrote the literal version from what you said. If you want the month to be the current month change the 9 to MONTH(TODAY()) which today will give you.. 9 for September The if was literaly saying if the month is equal to the 9th month of the year the cell value is "" also none as nothing.

[jgomez]

Thanks a lot.