dates and worksheets

[codeformat]

Ok here is what I am trying to do and I dont know if I can.

I have one worksheet with dates for a training event that has to be accomplished every year. On another worksheet I am tracking the people that still need to accomplish this even with a 1 or 0.

Is there a way to look at just the year part of the date and do something like:
if date >= current date then cell ="1"

I have to do this for a lot of cells.

Any help would be great.

[TankBuilder88]

You can do it by using the text function. For example if your date is in Cell A2 and you put in

Please Login or Register  to view this content.

[Leith Ross]

Hello codeformat,

Welcome to the Forum!

Say your date is in A1. You can add a IF statement to cell B1 like this...

Please Login or Register  to view this content.

You can drag this formula down the column as far as you need.

[codeformat]

I would like to do this as a macro if possible.

on the detail tab there are names and dates. I need to have it look at the date and if it is the current year put a 1 in the master tab under accomplished.

Also the number of cells with dates can change.