Challenge name:
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
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: