value entered in a cell based on a date in another cell.

[avidcat]

I need a formula that will basically just display a 1 or 0 in one cell based on the date in the cell next to it.

If the date is older than 180 days then a 0 will be displayed in the cell.

If the date is less than 180 days then a 1 will be displayed in the cell.

I have an attachement as an example.

thanks for any help.

Nick

[NBVC]

Try:

=--(A12>TODAY()-180)

Note: What if it is exactly 6 months.. if you want a 1, then change > to >= in above formula, else leave as is.

[avidcat]

Thanks, if Column A is blank is there a way to display nothing? I want to drag the formula down and have it only show if a date is entered.

thanks for your help.
Nick

[NBVC]

Try:

=IF(A12="","",--(A12>TODAY()-180))

[avidcat]

Thanks worked perfect.