11 months for expiry

  • Thread starter Thread starter Tia
  • Start date Start date
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
 
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
Click to expand...

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.
 
Back
Top