Hi, I'm trying to reference a cell that contains a dollar amount based on a date range.
This is what I'm trying (unsuccessfully to accomplish)
=IF([DATE SUBMITTED]@row >= DATE(2022, 12, 1), [DATE SUBMITTED]@row <= DATE(2022, 12, 28), "PO Amount Including Change Orders"
Looking for the amount in "PO Amount Including Change Orders" to show up if the cell "Date Submitted" falls within the date span.
Help Article Resources
Check out the Formula Handbook template!