SaraWitch
Active Member
- Joined
- Sep 29, 2015
- Messages
- 370
- Office Version
- 365
- Platform
- Windows
Hello peeps,
I want to calculate the days remaining from an expected end date and today but if a completion date is entered, then calculate number of days between this and received date.
I can get the formula to calculate the first bit but not the second:
Hope this makes sense, and any help would be appreciated!![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I want to calculate the days remaining from an expected end date and today but if a completion date is entered, then calculate number of days between this and received date.
I can get the formula to calculate the first bit but not the second:
¦ MrExcel Queries.xlsm | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Address | Notice received date | Expected end date | Pre-work | Days to complete | ||||
2 | Required | Date completed | Days to complete | should be | |||||
3 | Gnome Cave | 08/07/2024 | 04/08/2024 | Yes | 10/07/2024 | 16 | 2 | ||
Sheet3 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C3 | C3 | =B3+27 |
F3 | F3 | =IF(A3="","",IF(D3="No","",IF(D3="","",IF(D3="Yes",C3-TODAY(),IF(E3>0,B3-E3))))) |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
D3 | List | Yes, No |
Hope this makes sense, and any help would be appreciated!