Adding a month to a timestamp?

[Rich S]

Happy holidays, everybody:

I "get" that when dealing with timestamps you need to add time in seconds to denote a future time or date, e.g., to add a day to a timestamp the calc would be:

Timestamp + 86400

...since 60 (seconds) x 60 (minutes) x 24 (hours) = 1 day

But, how do you add a month since they can be from 28 days to 31 days? In my typical unwieldy fashion, would I create a Custom Function requiring multiple IF/CASE statements where "If it's January add 31 days; February, 28 days (except for leap years)..." etc.? I'm sure there's a _much_ simpler way of coding the calculation, I'm just not seeing it.

TIA for your help!

[comment]

Try =

Timestamp ( Date ( Month ( timestamp ) + 1 ; Day ( timestamp ) ; Year ( timestamp ) ) ; timestamp )

Edited December 10, 2011 by comment

[Rich S]

Brilliant, as usual. Thanks...and congrats on reaching 20,000 posts!