Ask Your Question

Revision history [back]

  1. Create a 1-row 2-column table.
  2. In its A1, put a date, e.g. 2018-07-21.
  3. In its B1, start entering the formula by entering equal sign, then clicking A1, then adding required number: =<A1>+16
  4. 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 TableNumber Recognition checked.

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

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

  1. Create a 1-row 2-column table.
  2. In its A1, put a date, e.g. 2018-07-21.
  3. 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.
  4. 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 TableNumber 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.