#### Luke M

##### Excel Ninja

**Challenge name:**

Add and subtract days to pre-1900 dates

* This is a formula challenge, designed to get you thinking creatively about how to solve a tricky problem using formulas only.

* Take the date in column A, add/subtract the number of days in col B, return correct date

* For simplicity, assume all dates use mm/dd/yyyy format, and all dates are greater than year 0.

* You should not use any helper cells, intermediate formulas, named ranges, or VBA

* The shortest formula I've found to do this is 160 characters, including the = sign.

* To find the length of your formula, put an apostrophe in front of the = sign, and then point a LEN function at it.(Note that the LEN function doesn't count the apostrophe)

Challenge Data

Add and subtract days to pre-1900 dates

**Challenge Description:*** This is a formula challenge, designed to get you thinking creatively about how to solve a tricky problem using formulas only.

* Take the date in column A, add/subtract the number of days in col B, return correct date

* For simplicity, assume all dates use mm/dd/yyyy format, and all dates are greater than year 0.

* You should not use any helper cells, intermediate formulas, named ranges, or VBA

* The shortest formula I've found to do this is 160 characters, including the = sign.

* To find the length of your formula, put an apostrophe in front of the = sign, and then point a LEN function at it.(Note that the LEN function doesn't count the apostrophe)

Challenge Data

Code:

```
Pre-1900 date Delta New Date
01/06/1885 30 02/05/1885
02/07/1700 15 02/22/1700
03/01/1601 -1 02/28/1601
01/01/1492 -7 12/25/1491
01/01/1000 -5 12/27/0999
```

Last edited: