I have a date of instruction in A2, a Todays date formula in B2 [B2 =TODAY()-A2] to calculate the date between the date in A2 to todays date.
In C2 I wish it to return the following
1. Up to 30 days '30% complete'
2. Over 30 days – 60 days – '50% complete'
3. Over 60 days to 90 days – '60% complete'
4. Over 90 days to 180 days - '70% complete'
5. Over 180 days – '80% complete'
I have the first part sorted.
=IF(B2 <30, "30% complete")
Could someone help me add the rest of the date ranges to the above? Also the formula I have entered only calculates less than 30 days but I need it to be equal to 30 or less than 30.
Bookmarks