date function?

  • Thread starter Thread starter beppe005
  • Start date Start date
B

beppe005

I would like to create a function that calculates fixed periods of time for
recurrent events, I mean something like that:
-I enter the frequency, either in days or in months, like every 1 month.
-Then I enter the first date, say 01-Jan-2004 (and the agenda event like
"shopping")
-At this point I have the list of the dates 01-Jan, 01-Feb, 01-March, and so
on...

I believe there is a function to do this, or something similar.

TIA
Beppe
 
I would like to create a function that calculates fixed periods of time for
recurrent events, I mean something like that:
-I enter the frequency, either in days or in months, like every 1 month.
-Then I enter the first date, say 01-Jan-2004 (and the agenda event like
"shopping")
-At this point I have the list of the dates 01-Jan, 01-Feb, 01-March, and so
on...

I believe there is a function to do this, or something similar.

TIA
Beppe
Click to expand...

Look up the DateAdd() function in VBA help.
 
Back
Top