easy (?) subtraction problem
thank you all - job done!!
"Norman Jones" wrote in message
...
Hi Tim,
One way:
=DATE(YEAR(A1)-1,MONTH(A1),DAY(A1))
---
Regards,
Norman
"Tim Marsh" <tmarsh-trousers-@-take off my trousers to
reply-blueyonder.co.uk wrote in message
...
Hi All,
Its the end of a long week here and my brain has already shut-down for
the weekend.
can someone tell me how i can subtract one year from a date. eg, if the
initial date is 19/09/2006 in cell A1 how do i calculate to get the
result of 19/09/2005 in cell B2? i need to do this for two sets of
approx. 3000 dates.
i can't think what formula or vba i would use even though it seems soooo
simple! i can't simply subtract 365 days because some might be in a leap
year.
tia,
Tim
|