Excel "If Then" Formula
Solved/Closed
jessica2991
Posts
4
Registration date
Thursday July 17, 2014
Status
Member
Last seen
July 30, 2014
-
Jul 17, 2014 at 03:50 PM
jessica2991 Posts 4 Registration date Thursday July 17, 2014 Status Member Last seen July 30, 2014 - Jul 30, 2014 at 01:34 PM
jessica2991 Posts 4 Registration date Thursday July 17, 2014 Status Member Last seen July 30, 2014 - Jul 30, 2014 at 01:34 PM
Related:
- Excel "If Then" Formula
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel formula - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Excel if color is red then - Guide
5 replies
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
Jul 17, 2014 at 04:01 PM
Jul 17, 2014 at 04:01 PM
jessica2991, Good afternoon.
It sounds a little confuse.
Do you want this comparison to wich date?
Do you want one answer for each cell?
Please, tell us more details about your lay-out.
It sounds a little confuse.
Do you want this comparison to wich date?
Do you want one answer for each cell?
Please, tell us more details about your lay-out.
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
Jul 21, 2014 at 12:28 PM
Jul 21, 2014 at 12:28 PM
jessica2991, Good afternoon.
I did an example for you.
http://speedy.sh/yrJdZ/21-07-2014-en-kioskea-Contract-Aging-Calculus-OK.xlsx
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
I did an example for you.
http://speedy.sh/yrJdZ/21-07-2014-en-kioskea-Contract-Aging-Calculus-OK.xlsx
Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
jessica2991
Posts
4
Registration date
Thursday July 17, 2014
Status
Member
Last seen
July 30, 2014
Jul 28, 2014 at 11:18 AM
Jul 28, 2014 at 11:18 AM
I am not able to open that file. Is there any way you can write the formula out? Thank you for your help!
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
Jul 28, 2014 at 12:49 PM
Jul 28, 2014 at 12:49 PM
jessica2991, Good afternoon.
I checked the link and it's OK!
A screenshot of the file:

C3 --> =IF(DATEDIF(B3,TODAY(),"d")<=5,"x","")
D3 --> =IF(AND(DATEDIF(B3,TODAY(),"d")>=6,DATEDIF(B3,TODAY(),"d")<=15),"x","")
E3 --> =IF(AND(DATEDIF(B3,TODAY(),"d")>=16,DATEDIF(B3,TODAY(),"d")<=30),"x","")
F3 --> =IF(AND(DATEDIF(B3,TODAY(),"d")>=31,DATEDIF(B3,TODAY(),"d")<=42),"x","")
G3 --> =IF(DATEDIF(B3,TODAY(),"d")>42,"x","")
Copy them down
C13 --> =CONT.SE(C3:C12;"X")
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
I checked the link and it's OK!
A screenshot of the file:

C3 --> =IF(DATEDIF(B3,TODAY(),"d")<=5,"x","")
D3 --> =IF(AND(DATEDIF(B3,TODAY(),"d")>=6,DATEDIF(B3,TODAY(),"d")<=15),"x","")
E3 --> =IF(AND(DATEDIF(B3,TODAY(),"d")>=16,DATEDIF(B3,TODAY(),"d")<=30),"x","")
F3 --> =IF(AND(DATEDIF(B3,TODAY(),"d")>=31,DATEDIF(B3,TODAY(),"d")<=42),"x","")
G3 --> =IF(DATEDIF(B3,TODAY(),"d")>42,"x","")
Copy them down
C13 --> =CONT.SE(C3:C12;"X")
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Didn't find the answer you are looking for?
Ask a question
jessica2991
Posts
4
Registration date
Thursday July 17, 2014
Status
Member
Last seen
July 30, 2014
Jul 30, 2014 at 01:34 PM
Jul 30, 2014 at 01:34 PM
Thank you very much! This was exactly what I needed!
Jul 21, 2014 at 11:02 AM
0-5 Days 6-15 Days 16-30 Days 31-42 Days >42 Days
X