Multiple IF functions with dates
Closed
CJ
-
Jan 15, 2015 at 12:14 PM
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Jan 20, 2015 at 11:29 PM
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Jan 20, 2015 at 11:29 PM
Related:
- Multiple IF functions with dates
- Allow multiple downloads chrome - Guide
- How to delete multiple files at once - Guide
- Photoshop multiple selections - Guide
- Accessor and mutator functions c++ - Guide
- Multiple if statements in excel - Guide
1 response
ArashMan
Posts
38
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
Jan 20, 2015 at 11:29 PM
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
