Count months instead of days.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field in a form that coducts the following calculation. =[Event
Date]+180 How do I get it to count calendar months instead of days? I
appreciate any help.
 
Use the DateAdd function.

=DateAdd("m", 1, [Event Date]) will add 1 month, =DateAdd("m", 2, [Event
Date]) will add 2, and so on.
 
And

=DateAdd("m", -1, [Event Date]) will subtract 1 month,
=DateAdd("m", -2, [Event Date]) will subtract 2 months,

and so on.
 
Back
Top