Please post an example of what you're trying to do and how it's not
working.
DateAdd() can be used as a calculated field, and any of the three
arguments can be a field name in brackets; you can also call it from a
VBA function - however, I don't believe you can call it directly from
a Macro (I don't use macros much though).