How do I write a formula for two columns looking for between dates and status? i

Angie Votek · 04/10/21

How do I write a formula for two columns looking for between dates and status? i.e. Start Date is 04/01/21 to 06/30/21 and Status is In Progress.

Thank you

Bassam Khalil · 04/11/21

Hi @Angie Votek

Hope you are fine, you can do that with IF with AND function. Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Angie Votek · 04/11/21

Bassam,

Thank you for any direction! I know you have alot going on. Hope you are well, too!

Again, thank you!

Bassam Khalil · 04/12/21

@Angie Votek

i will come back to you with the formula ASAP, but what do you want the formula to return when it finds the exact match, did you want it to give the row number for example, or task name.

Angie Votek · 04/13/21

Thank you so much! Sorry, yes, it would be the sum total of the status between those dates.

How do I write a formula for two columns looking for between dates and status? i

Answers

Help Article Resources

Categories