Check a box when Past due more the 1 year

Matt Stephan

New to this all. I'm trying to write a formula where if a date is more than 1 year in the past, it will check a box, but if no date is entered in a row the checked box will remain unchecked. I need to create a training log where not everyone is required to have the training. But certain training is on an annual basis.

Mike TV

@Matt Stephan

=IFERROR(IF(NETDAYS([Asbestos Awareness]@row, TODAY())>=365, 1, 0), "")

Mike TV

@Matt Stephan

One quick way to do it would be a formula like this:

=IF(NETDAYS([Asbestos Awareness]@row, TODAY())>=365, 1, 0)

Matt Stephan

Thanks for the help. It worked to a degree.

Is there anyway to eliminate the invalid data type?

Mike TV

@Matt Stephan

=IFERROR(IF(NETDAYS([Asbestos Awareness]@row, TODAY())>=365, 1, 0), "")

Matt Stephan

That worked, Thank you