11 months for expiry

T

Tia

Thank you for your continuos support
I'm trying to make a data base for the employees example the insurance
card is dated today and will expire after 11 months.
What is the formula that will add 11 months date
Insurance expiry date :??

Thank you in advance
 
F

fredg

Thank you for your continuos support
I'm trying to make a data base for the employees example the insurance
card is dated today and will expire after 11 months.
What is the formula that will add 11 months date
Insurance expiry date :??

Thank you in advance

Look up the DateAdd function in VBA help.
=DateAdd("m",11,[StartDate])
The above value ought not be saved in any table.
As long as you have stored the [StartDate] anytime you need the expiry
data, re-calculate it as above.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top