Ask Your Question
1

date + 31 days in calc? [closed]

asked 2013-03-31 17:00:28 +0200

digger gravatar image

updated 2013-04-16 13:14:41 +0200

manj_k gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-29 16:22:48.495215

Comments

1

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

JohnSUN gravatar imageJohnSUN ( 2013-03-31 19:17:24 +0200 )edit

Well I didn't know it can be done so easy. Thanks :)

digger gravatar imagedigger ( 2013-04-05 23:12:14 +0200 )edit

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

Thanks!

qubit gravatar imagequbit ( 2013-04-09 08:13:34 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2013-04-09 12:03:02 +0200

JohnSUN gravatar image

Just use formula like as

=<address_of_cell_with_start_date>+<count_of_days>

For 31 days it will be

=A2+31
edit flag offensive delete link more

Comments

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.

UncleCrust gravatar imageUncleCrust ( 2016-02-26 21:29:57 +0200 )edit

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

JohnSUN gravatar imageJohnSUN ( 2016-02-27 08:32:41 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2013-03-31 17:00:28 +0200

Seen: 11,210 times

Last updated: Apr 09 '13