I-9 shred date calculation formula

[RLM406]

I am attempting to create a spreadsheet that calculates the shred date of I-9's based on three date columns; hire date, rehire date and termination date. The I-9 forms must be kept three years after the date of hire/rehire, or one year after the date terminated, whichever is later. I want to have a formula that compares all three dates then chooses the correct shred date and shows that date to me.
Thanks for any ideas this one has me stumped.

[Gatti]

Hello!!

Could you please post a sample workbook with your problem?

Thanks

[RLM406]

Spreadsheet example.xlsx
Here is a spreadsheet example for what I am attempting. Basically just wanting to have a column with the shred date in it added to my larger employee info tracking spreadsheet.

[José Augusto]

Hi
Use in F2 and copy down

Please Login or Register  to view this content.

[RLM406]

Thank you! This is great

[alackey]

I am having problems with the formula. I am also trying to create a tickler file, but I am unable to use the formula correctly. HELP!!

[José Augusto]

Not for that thread.
Sorry

[tscherc]

This thread was incredibly helpful. Yet, I am including all current hires in this spreadsheet along with termed employees. What formula or IF statement would I need to add to alert me to RETAIN the file vs. a shred date?

[protonLeah]

tscherc,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.