Prev: Formula addition causes random #REF!
Next: excel: How to set up a formula for a range of numbers ie. 3.5-5..
From: Joe User on 26 Apr 2010 14:23
"jlo" wrote:
> =DATEDIF(A3,TODAY(),"d")
> now, I want to add to this formula, if possible, to say
> if a date is entered into the second column, then just
> calculate "Date Sent" - "Date Returned" in the same
> "Total Days" column

=IF(B3="",TODAY(),B3) - A3


----- original message -----

"jlo" wrote:
> In my "Total Days" column, I have the following formula and it works:
>
> E4 is Date sent to Vendor
>
> =DATEDIF(A3,TODAY(),"d")
>
> now, I want to add to this formula, if possible, to say if a date is entered
> into the second column, then just calculate "Date Sent" - "Date Returned" in
> the same "Total Days" column...is this possible?? I manually entered the "1"
>
> Date sent to Vendor Date Returned From Vendor Total Days
> out to Vendor
> 4/22/2010 4
> 4/22/2010 4/23/2010 1
> 4/23/2010 3
> 4/23/2010 3
> 4/23/2010 3
> 4/23/2010 3
> 4/26/2010 0
> 4/26/2010 0
>
>
>
First  |  Prev  | 
Pages: 1 2
Prev: Formula addition causes random #REF!
Next: excel: How to set up a formula for a range of numbers ie. 3.5-5..