DateAdd problem

[deb]

i want to calculate and end date for a lease term

pretty easy =DateAdd("yyyy",+[Term],[StartDate])

so my start date is 01/07/09 and my term is 1 year so my end date is 01/07/10

trouble is, what it should be is 30/06/10

my question is how do i get the above formula to deduct one day to get the
correct date?

 

[Allen Browne]

=DateAdd("yyyy",+[Term],[StartDate]) - 1

 

[deb]

LOL - now doesnt that make me feel dumb!

i was thinking i'd have a proble because i'd dont the calc in years but i
wanted to deduct one day

thank you so much
--
deb

=DateAdd("yyyy",+[Term],[StartDate]) - 1

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

i want to calculate and end date for a lease term

pretty easy =DateAdd("yyyy",+[Term],[StartDate])

so my start date is 01/07/09 and my term is 1 year so my end date is
01/07/10

trouble is, what it should be is 30/06/10

my question is how do i get the above formula to deduct one day to get the
correct date?

.