formula or macro to add +1 month to date

[usl]

Hi,

I got in column A dats e.g. 01.01.2006
in column B I got time and in column C I got the actual value.

for each row I got a new value for every 15 min.

so 24 hours for the 01.01.2006 ist then from A2:A2977

I woudl like in ColumnD to add 1 month to the the value from column A,
hoe can I do that .

a formula or a macro to change the month January to e.g. Febura in all entries from A2:A2977.

hope you can help me
thanks a lot in advance
usl

 

[Andrew Poulsom]

Try eg:

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

 

[pgc01]

Hi usl

also, if a1 is just date, ex: a1= 2006-01-01:

=edate(a1,1)

if in A1 you have not just the date but also the time you have to add it.

Ex: a1= 2006-01-01 12:34:56. In this case

=edate(a1,1)+(a1-int(a1))

Format the result as date or datetime.

You may have to enable the Analisys ToolPack (Tools>Add-ins)

Hope this helps
PGC