can this function do this?
 

I am not sure how to make this happen. what I need to do is have sort of
reminder when something needs to be done. However, what I was thinking of is
to use IF statement. There is a date column and drywall access required
column. I am wondering if I can use the drywall access required column which
only has entry of yes and no and use the date column to be 10 days later in
some kind of filter so then all the jobs that are ready can have their
drywall access holes checked out or done. I hope you can tell what I mean.

Thanks Jackie

can this function do this?
 

Do you mean something like:

=IF(NOW()=A1+10,"Yes","No")

entered in your "Drywall access" column, assuming your dates are in
column A? If so, then copy the formula down as required.

Hope this helps.

Pete