First time here? Check out the FAQ!

1 | initial version |

- Create a 1-row 2-column table.
- In its A1, put a date, e.g. 2018-07-21.
- In its B1, start entering the formula by entering equal sign, then clicking A1, then adding required number:
`=<A1>+16`

- The B1 cell will be formatted as number (and thus have the result
`43318`

). Right-click B1, and choose`Number Format...`

; then select`Date`

.

You may also need to check that you have `Table`

→`Number Recognition`

checked.

2 | No.2 Revision |

- Create a 1-row 2-column table.
- In its A1, put a date, e.g. 2018-07-21.
- In its B1, start entering the formula by entering equal sign, then clicking A1, then adding required number:
`=<A1>+16`

- The B1 cell will be formatted as number (and thus have the result
`43318`

). Right-click B1, and choose`Number Format...`

; then select`Date`

.

You may also need to check that you have `Table`

→`Number Recognition`

checked.

Of course, you may have 3-cell table, and use B1 to enter number of days, and C1 to add B1 to A1... or whatever you need.

3 | No.3 Revision |

- Create a 1-row 2-column table.
- In its A1, put a date, e.g. 2018-07-21.
- In its B1, start entering the formula by entering equal sign, then clicking A1, then adding required number:
`=<A1>+16`

- The B1 cell will be formatted as number (and thus have the result
`43318`

). Right-click B1, and choose`Number Format...`

; then select`Date`

.

You may also need to check that you have `Table`

→`Number Recognition`

checked.

Of course, you may have 3-cell table, and use B1 to enter number of days, and C1 to add B1 to A1... or whatever you need.

Here is a sample.

4 | No.4 Revision |

- Create a 1-row 2-column table.
- In its A1, put a date, e.g. 2018-07-21.
- In its B1, start entering the formula by entering equal sign, then clicking A1, then adding required number:
`=<A1>+16`

. Finish the formula by`Enter`

. - The B1 cell will be formatted as number (and thus have the result
`43318`

). Right-click B1, and choose`Number Format...`

; then select`Date`

.

You may also need to check that you have `Table`

→`Number Recognition`

checked.

Of course, you may have 3-cell table, and use B1 to enter number of days, and C1 to add B1 to A1... or whatever you need.

Here is a sample.

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.