Need support with a Start Date, End Date, and Completed Date formula.

AlmightyEx

New Member
Joined
Jun 11, 2023
Messages
3
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
  4. Web
Hi everyone-

I am trying to have my 'remaining column' to display the days between 'start date columns' and 'end date columns'. In addition, if the 'completed column' has a date then the 'remaining column' will display 0 because it is completed, but if it does not have a date then the 'remaining column' will have overlaps days like the picture below. Wonder if anyone can support me with this? Thanks

1686475067899.png
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Hi
And welcome
If I correctly understand: try
Excel Formula:
C3=IF(D3="",B3-A3,0)
 
Upvote 0
Hi
And welcome
If I correctly understand: try
Excel Formula:
C3=IF(D3="",B3-A3,0)
Almost! My fault if my wording was a bit confusing-was trying my best to explain this tricky formula. So, if the 'completed column' was blank and the 'end date column' was not completed on time. Then I need it to calculate days after the end date column like cell C3. However, If the 'completed column' is blank and the 'end date' is further out of todays date, then it will display the remaining days like cell C5.
 
Upvote 0
Solved it! Thanks @mohadin for support.

=IF(D2<>"", 0, IF(B2="", "", IF(B2<TODAY(), B2-TODAY(), B2-TODAY())))
 
Upvote 0
Solution

Forum statistics

Threads
1,223,236
Messages
6,170,912
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top