Forum Discussion
Order date reminder
Use this formula
=IF(A2="","",IF(AND(B2="",A2<(TODAY()-$F$2)),"Yes",""))
This way, if the data in column A is blank, then there is no "Yes' generated, but the rest of the formula is as it was before, except I removed the named reference to "GraceDays" and just refer to the cell F2, which contains the number of days.
[FYI, I had used a slightly advanced feature of Excel, called a "named range," to refer to that cell. It made the formula more "readable," but you can also use the cell reference, F2. And the dollar signs, make it an absolute reference, meaning it stays constant, even as you copy the formula down through multiple rows.]
Since you're a relative beginner, you might find this website useful. https://exceljet.net/search?query=named+range
You can search for various functions, abilities of Excel. There are also videos, and YouTube has lots of useful resources as well.
Use this formula
=IF(A2="","",IF(AND(B2="",A2<(TODAY()-$F$2)),"Yes",""))
This way, if the data in column A is blank, then there is no "Yes' generated, but the rest of the formula is as it was before, except I removed the named reference to "GraceDays" and just refer to the cell F2, which contains the number of days.
[FYI, I had used a slightly advanced feature of Excel, called a "named range," to refer to that cell. It made the formula more "readable," but you can also use the cell reference, F2. And the dollar signs, make it an absolute reference, meaning it stays constant, even as you copy the formula down through multiple rows.]
Since you're a relative beginner, you might find this website useful. https://exceljet.net/search?query=named+range
You can search for various functions, abilities of Excel. There are also videos, and YouTube has lots of useful resources as well.
