How can I find the max date that is less than today in a range that is mixed with both ACTUAL and PROJECTED Dates:
as you see here I have a row of dates. Some dates are actual, others are projected. I want to open the spreadsheet and say "What is the latest PROJECTED date that is less than today?"
Aucun commentaire:
Enregistrer un commentaire