Software

Ask something
Question Locked

Need help with Excel please

0 helpful
2 replies

by kentaylor

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a list generated with the List manager.
It lists employee names (last name, first name) and dates of several qualifications they all need( Qual1, Qual2, Qual3, etc.)
I then added and expiration date for each qual (Qual1, Qual1 exp, Qual2, Qual2 exp, etc)
My question is i need a formula to list the names of the employees who are within 90 days of any given qual and the qual they are due for.

Any help would be GREATLY appreciated!
Thanks!
Ken

2 replies

by peconet tietokoneet

=IF(TODAY()-Qual1>90,TODAY()-Qual1,"")

It will show the number of days overdue, but only if it is greater than 90

This discussion is closed to new replies.