Greetings!

I'm still learning a lot about excel, so any help would be appreciated.

I need to assign a vender ID to transactions within a certain date range.
So, for example, what I need is some kind of formula that would, in a new column, assign the ID 200 to every row that has a date between 01/01/10 and 01/31/10.

Thanks!