Hallelujah! I think I've got it! Your formula did help me, FDibbins.
Here is the final formula I used in case anyone else is having a similar issue:
=AND(C7="Caregiver",AB7<12,DATE(2013,MONTH(AD7),DAY(AD7))<TODAY()+30)
Hallelujah! I think I've got it! Your formula did help me, FDibbins.
Here is the final formula I used in case anyone else is having a similar issue:
=AND(C7="Caregiver",AB7<12,DATE(2013,MONTH(AD7),DAY(AD7))<TODAY()+30)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks