# Calculate work order aging with IF statement for blanks.

#### Ybenn

##### New Member
Hello.

I need to calculate the age of a work order using the start date (a2) and end date (b2). The “open” work orders will have a blank end date.

I want to write a formula that will use today’s date as the end date if the end date cell is blank. I’m assuming I use an IF statement, but not sure how to write it.

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

#### JoeMo

##### MrExcel MVP
=if(b2="",today()-a2,b2-a2)

#### sandy666

##### Well-known Member
another way

A
B
C
D
1
StartDateEndDateAge
2
10/07/2019​
20/07/2019​
10​
=IFERROR(CHOOSE(MATCH(--ISBLANK(B2),{0,1},0),DATEDIF(A2,B2,"d"),DATEDIF(A2,TODAY(),"d")),"")
3
20/07/2019​
30/07/2019​
10​
4
30/07/2019​
10/08/2019​
11​
5
10/08/2019​
5​
6
20/08/2019​
7
30/08/2019​

1,102,050
Messages
5,484,411
Members
407,438
Latest member
DKrakken

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...