Calculate total days between two dates in excel based on if another cell is not empty - PLEASE HELP!!!!!

[lawoffashioninc]

I am sure this has been asked before, but I need all the assistance I can get with this...We have implemented a new tracking system that requires us to calculate the total numbers of days between two dates if one cell contains a date. However, one of the dates you must add one day to it then subtract it from the other date.

In simple terms, column C must have a date before we can calculate days between the two dates and provide a new expiration date.

I tried the DateIF formula, but I keep getting an error. Any assistance you can provide is greatly appreciated.

Oh, we can't use pivot tables either.

Example...

Column A - Family Initial Expiration Date
June 29

Column B -Family Submit Request:
May 15

Column C - Organization Denies Request
May 24

Column D - Total Days
9 days (Must Equal 9 days by subtracting May 16 from May 24)

Column E - Family's New Expiration Date
July 8 (June 29th + 9days)

 

[dreid1011]

If you already have the dates in the cells, then all you really need is something like this:

In col D:
=IF(C1="","",C1-B1)

In col E:
=IF(C1="","",A1+D1)

With your E col formatted as date.

 

[lawoffashioninc]

Thank you! What if I want the cell to populate zero if the cell is empty but populate the dates if the cell has a date in it? Also, how can specific rows be automatically copied to another sheet but in the same workbook?

 

[dreid1011]

To show 0, change the formulas like this:

=IF(C1="",0, ... )

As far as the auto copy, that would most likely be solved with VBA.