Excel "If Then" Formula
Solved/Closed
jessica2991
jessica2991
- Posts
- 4
- Registration date
- Thursday July 17, 2014
- Status
- Member
- Last seen
- July 30, 2014
jessica2991
- Posts
- 4
- Registration date
- Thursday July 17, 2014
- Status
- Member
- Last seen
- July 30, 2014
Related:
- Excel "If Then" Formula
- Excel @ in formula ✓ - Forum - Excel
- How to copy data from one sheet to another in excel using formula - Guide
- Excel position formula ✓ - Forum - Office Software
- How to insert picture in excel using formula - Guide
- How to change date format in excel using formula - Guide
5 replies
Mazzaropi
Jul 17, 2014 at 04:01 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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
Jul 21, 2014 at 12:28 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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
Jul 28, 2014 at 11:18 AM
- Posts
- 4
- Registration date
- Thursday July 17, 2014
- Status
- Member
- Last seen
- July 30, 2014
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
Jul 28, 2014 at 12:49 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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
Jul 30, 2014 at 01:34 PM
- Posts
- 4
- Registration date
- Thursday July 17, 2014
- Status
- Member
- Last seen
- July 30, 2014
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