halesowenmum
Active Member
- Joined
- Oct 20, 2010
- Messages
- 383
- Office Version
- 365
- Platform
- Windows
Hiya, I have two columns side by side each with a date in and the dates are as follows:
L M
7 03/01/2014 03/01/2014
They are for a task which takes place on that day and finishes on that day. So the task takes one day. However, the formula to calculate how many days it's taken:
=IF(M7-L7=0,"",M7-L7)
returns a blank/no result since as far as Excel is concerned it's the same day, not a whole day that's passed.
Is there a way of amending the above formula so that where the dates are the same instead of it returning "", it returns a 1, but ONLY in this instance (as this is the only occasion when the formula doesn't return what I need)????
Thanks very much.
Have just changed the "" for "1" which does the trick. Hopefully this will be ok.
L M
7 03/01/2014 03/01/2014
They are for a task which takes place on that day and finishes on that day. So the task takes one day. However, the formula to calculate how many days it's taken:
=IF(M7-L7=0,"",M7-L7)
returns a blank/no result since as far as Excel is concerned it's the same day, not a whole day that's passed.
Is there a way of amending the above formula so that where the dates are the same instead of it returning "", it returns a 1, but ONLY in this instance (as this is the only occasion when the formula doesn't return what I need)????
Thanks very much.
Have just changed the "" for "1" which does the trick. Hopefully this will be ok.
Last edited:
