Date + 31 days in calc?

[digger]

Hello. I want to make a simple script/macro in calc, when i input some random ‘date’ in cell - i want it to output ‘date’ + 31 days.

Examples:

• input: 2013-03-01 => output: 2013-04-01
  
• input: 2013-04-05 => output: 2013-05-06
  
• input: 2013-02-08 => output: 2013-03-11
  
  and so on.

Is it possible?

[JohnSUN]

Of course it’s possible. Would you just use a formula =A2+31 ?

[digger]

Well I didn’t know it can be done so easy. Thanks

[qubit1]

@JohnSUN – please turn your comment into an Answer so we can use it to resolve this question

Thanks!

[JohnSUN]

Just use formula like as

=<address_of_cell_with_start_date>+<count_of_days>

For 31 days it will be

=A2+31

[UncleCrust]

My A3 contains: =DATEVALUE(“2016-02-13”)
The cell formatting for column A is Date->Fri, Dec 31, 99 which displays the desired value ‘Sat, Feb 13, 16’ in A3.
If I set A4 to be =a3+1, ### is displayed. I’m trying to make a timecard where column A contains the date (in the desired format) for each day of the time period. I wanted to be able to enter the pay period start date in the first date cell then, using a formula in the succeeding cells, have the subsequent dates propagate automatically.

[JohnSUN]

Just increase the width of the column or Format - Cells - Alignment - Shrink to fit cell size