Need help configuring dates

hello all--

what im trying to do is consolidate things for a company
that is currently using 12-15 WORKS yes i said works spreadsheets.

what im shooting for is one database with several tables.....well yall get
the idea.

the problem im having is they need to generate expiration dates for there
product and what they want is a 24 month validation but with no day listed
in that date(mm/yyyy)?????

ANY BODY have any ideas

i have a formula i was able to find....but its not quite what i need
=DateSerial(Year([StartDate]),Month([StartDate])+24,Day([StartDate]))

!!!!HELP!!!!!

try

=format(([startdate] + 730),"mm,yyyy")

thanks cteakle

looks good where do i put that formula at??

and i tried that out and insead of a "/" between set it
inserts a ","

is there something you may have missed??

brian

Hi
Put the formula wherever you were putting that dateserial one.

Sorry - i had the format wrong. I think you just need to put this instead.
=format(([startdate] + 730),"mm/yyyy")

chris