Get instant live expert help on I need help with to date or to date

I have three columns, 1st = title of project. 2nd = project due date. 3rd = expected completion date. I need to use conditional formatting to color the title for each project either green (if expected completion date is 30 or more BUSINESS days before due date), yellow (if expected date is between 30 and 15 business days before due date), or red (if expected date is 15 or less business days before due date).

Hello I am trying to create a spreadsheet in excel with Name, date paid, week or month subscription, and the due date, but would like the due date column to turn red or a certain color when the date is up.

I need the formula for time accrual to auto populate in E4 based on certain criteria. example: B4 = hire date E4= accrual rate If todays date is equal to or greater than 60 days but less than 1 year from B4 date then E4 = 1 If todays date is equal to or greater than 3 years but less than 4 years from B4 date then E4 = 1.08 If todays date is equal to or greater than 5 years but less than 9 years from B4 date then E4 = 1.5 If todays date is equal to or greater than 10 years but less than 14 years from B4 date then E4 = 1.58 If todays date is equal to or greater than 15 years from B4 date then E4 = 1.92

Goal, is to mark Y for duplicate records in last column. In column J, if there is a 2 or 3 (Then there are 2 or 3 duplicates). Always keep the latest "Date Acquired" date. Also keep the latest "Date Assigned" and "Date Acquired". If there is no "Date Acquired", then keep the latest "Date Assigned".

Progress Status: Registration date to display 1-45 (as formula is) or the actual date if earlier than H3