Date + 30 days

[zudecke]

Hi,

I'm trying to record trial periods for people using a particular software.

How do I set a cell to recognise the previous columns start date and + 30 days on to the end date?

Please see attached spreadsheet.

Thanks,

Nick K

[Blake 7]

Maybe =INT(1)*B2+30 in C2

[zbor]

Try this:

=B2+30

[teylyn]

@Blake7: why the Int(1)* ??? It does not really make a difference to

=B2+30

does it? What am I missing? 1 is an Integer. Int(1) = 1
1 * anything = anything.

What's the reasoning?

[Blake 7]

Jeez - I hope i didn't hurt anyone???????

No reason what so ever, slip of the keyboard. I apologise profusely, I will wonder off now to a dark room and punish myself physically!!

=INT(B2+30) or b2+30 = the same.

Please forgive me?

[zudecke]

I think teylyn was only asking as she thought she may have been missing something - not being rude lol.

Thank you both for your help! Love it here!

Zudecke

[Blake 7]

It's too late,,,,,,, i've done it. 1 * flogging myself with a phone wire = 1 * flogging myself with a phone wire !!!.

[teylyn]

Blake,

no need to throw your toys. I'm just trying to understand your suggestion, eager to learn if there is something in it.

Your first formula

=INT(1)*B2+30

looks a bit different from the formula in your next post.

=INT(B2+30)

I've learned that with Excel, detail really matters. So I was just trying to understand what you're doing, not trying to flog you.

In any case: the Int() around the B2+30 does not make a difference if we're just looking at dates, disregarding time. And since the OP was just interested in incrementing a date by 30 days, I think zbor's suggestion of

=B2+30

still does the trick most efficiently.

cheers,