+1 to Date Macros?

[litlmike]

My goal is to take today's date and put it into an excel file (this I can do), and then go to the next row and add 1 to the date, doing this for 365 days. So starting today, I should have 06/14/2007 through 06/14/2007, one in each row.

The problem is the only way I can think to do this is to create a rule for every month because every month has a different number of days in it. So I would have to +1 to todays date, until the Day is =30, then I would have to +1 to the Month, and do that 12 times. Though it would work, it seems ridiculous, it seems that there would be a way to just +1 to today's date and loop that. (i.e. February would be +1 to the Day until Day=28, then +1 to the Month)

Sorry, my help file does not work, and I am sorry if this is in the help file already.

Thanks.

#include <ExcelCOM_UDF.au3>

For $iCC = 1 To 365
    _ExcelWriteCell($oExcel, @MON & "/" & @MDAY & "/" & @YEAR, $sRangeOrRow, $iColumn) ; Date
        $sRangeOrRow += 1
WEnd

Edited June 14, 2007 by litlmike

[GaryFrost]

look at _DateAdd

[litlmike]

look at _DateAdd

Ahhh... that sounds good. Since my Help File is broken, and since those UDF's cannot be found in the Online Documentation, could you provide me with the Syntax for _DateAdd .

Thanks

[Mast3rpyr0]

heres the html file from the help file in attachments.

[litlmike]

heres the html file from the help file in attachments.

You are awesome.. thanks!

[evilertoaster]

http://www.autoitscript.com/autoit3/docs/

In case you didn't know...

[Helge]

http://www.autoitscript.com/autoit3/docs/

In case you didn't know...

since those UDF's cannot be found in the Online Documentation

He obviously knew.

@litlmike : You can find it in online beta-docs though : http://www.autoitscript.com/autoit3/files/...ns/_DateAdd.htm

[Mast3rpyr0]

oh lol well glad it helped litlmike

[litlmike]

He obviously knew.

@litlmike : You can find it in online beta-docs though : http://www.autoitscript.com/autoit3/files/...ns/_DateAdd.htm

I had no idea the beta helpfiles were online...

;(

But thanks for letting me know

http://www.autoitscript.com/autoit3/files/beta/autoit/docs/

Edited June 14, 2007 by litlmike