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
 
Ad

Advertisements

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

Similar Threads

Expiry dates query 1
expiry dates reminder 1
expiry dates report 2
monthly expiry 9
Subtracting months formula 5
Data Entry Form. 3
Problem with "IF" function 8
Excel Excel-Conditional Formatting 0

Top