To which calendar function do you refer?

In cells,say the event date is in A2, for the reminder cards in B2 enter

=A2-14

and for the invitations in C2 enter

=A2-42

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"labels using an Outlook contact category"
<labelsusinganOutlookcontactcategory@discussions.microsoft.com> wrote in
message news:C98ED24E-AF57-4632-ACFE-6695BFD147FA@microsoft.com...
>I want to create an event calendar in Excel by setting up formulas (event
> date minus two weeks for reminder cards), (event date minus six weeks for
> invitations) based on the end date. Is there an easy way to subtract
> weeks
> in the calendar function?