Multiple IF functions with dates
Closed
CJ
-
Jan 15, 2015 at 12:14 PM
ArashMan
ArashMan
- Posts
- 41
- Registration date
- Monday December 15, 2014
- Status
- Member
- Last seen
- February 18, 2015
Related:
- Multiple IF functions with dates
- If function using dates - Guide
- IF functions with dates ✓ - Forum - Excel
- Some help needed about IF function with dates ✓ - Forum - Excel
- Using the IF function for dates ✓ - Forum - Excel
- Using IF function with dates ✓ - Forum - Excel
1 reply
ArashMan
Jan 20, 2015 at 11:29 PM
- Posts
- 41
- Registration date
- Monday December 15, 2014
- Status
- Member
- Last seen
- February 18, 2015
Jan 20, 2015 at 11:29 PM
Dear CJ
i dont understand what you mean by bellow parts
date in A2 to produce number of days difference
date in A1 to produce number of days difference
do your mean the difference of larger date minus the other?
if it is you can use something like this in A3 cell
=if(A1<A2,A2-A1,if(A1>A2,A1-A2))
i hope its what are you looking for
i dont understand what you mean by bellow parts
date in A2 to produce number of days difference
date in A1 to produce number of days difference
do your mean the difference of larger date minus the other?
if it is you can use something like this in A3 cell
=if(A1<A2,A2-A1,if(A1>A2,A1-A2))
i hope its what are you looking for