Hi all,
my first post so sorry if the structuring of it is off a little. I am working on a Loan Tracking Sheet at work and am faced with two problems:
1.) I have a column that is full of dates that financial statements were delivered to us, and to track this I wanted to create a conditional format that would highlight any cells that had been received within the current quarter + 30 days. My issue here is I can obviously put down a date for the end of each quarter + 30 days which is Q1 + 30 = 04/30/2022, Q2 + 30 = 07/30/2022, Q3 + 30 = 10/30/2022, and Q4 + 30 = 01/30/2023, which is simple but would force me to go back at the end of every quarter and update the conditional format. So, how would I create a formula that would automatically evaluate whether the date that the financial statement was delivered falls within the current quarter + 30 days?
2.) I have a column that has the dates we received Tax Returns from customers, and we need to highlight any cell that has not been delivered to us before May 18th. The only issue here is that several customers have extensions which would make the date for some November 17th. How would I differentiate the cells that have an extension and those that don't so that those that have an extension would not be mistakenly highlighted?
Sorry for the long post, but thank you in advance.
my first post so sorry if the structuring of it is off a little. I am working on a Loan Tracking Sheet at work and am faced with two problems:
1.) I have a column that is full of dates that financial statements were delivered to us, and to track this I wanted to create a conditional format that would highlight any cells that had been received within the current quarter + 30 days. My issue here is I can obviously put down a date for the end of each quarter + 30 days which is Q1 + 30 = 04/30/2022, Q2 + 30 = 07/30/2022, Q3 + 30 = 10/30/2022, and Q4 + 30 = 01/30/2023, which is simple but would force me to go back at the end of every quarter and update the conditional format. So, how would I create a formula that would automatically evaluate whether the date that the financial statement was delivered falls within the current quarter + 30 days?
2.) I have a column that has the dates we received Tax Returns from customers, and we need to highlight any cell that has not been delivered to us before May 18th. The only issue here is that several customers have extensions which would make the date for some November 17th. How would I differentiate the cells that have an extension and those that don't so that those that have an extension would not be mistakenly highlighted?
Sorry for the long post, but thank you in advance.
