Hi,
The formula will be very similar to the excellent answer ConneXionLost gave you on this thread:
https://www.msofficeforums.com/excel...el-2010-a.html
The only extra piece you need is how to return today's date. You can do this using the TODAY() function.
Does that help?