Previous Topic Next Topic

Multiple IF functions with dates

Closed
CJ - 15 Jan 2015 à 12:14
ArashMan Posts 38 Registration date Monday 15 December 2014 Status Member Last seen 18 February 2015 - 20 Jan 2015 à 23:29
Hello,

I am rather new to creating Excel formula

I want to create the following rule working with dates:

IF date in A1<date in A2, then date in A3 - date in A2 to produce number of days difference
BUT IF date in A1>date in A2, then date in A3 - date in A1 to produce number of days difference

Is this possible?

Many thanks
C


Related:

1 response

Réponse 1 / 1
ArashMan Posts 38 Registration date Monday 15 December 2014 Status Member Last seen 18 February 2015 1
20 Jan 2015 à 23:29
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

Similar discussions

Need to calculate monthly avg and yearly miles from odometer
jamishore -
vcoolio -

5 responses
encryption message several time in chat
measking -
HelpiOS -

1 response