Changing dates using a formula

Hi there

Please can you help. Im trying to set something up which will enable me to put in any date into a spread sheet and then i want it to calculate 2 weeks previous and give me that date.

Basically i have a job to set up a time table for meetings, i want to be able to put in any date then below it will tell me the date i need to send out agendas which will usually be 2 weeks before the meeting.

I hope this makes sence and someone can help!

Thanks
Natalie

=A1-14

assuming your date is in A1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"natys" <[email protected]> wrote in message
news:[email protected]...
>
> Hi there
>
> Please can you help. Im trying to set something up which will enable
> me to put in any date into a spread sheet and then i want it to
> calculate 2 weeks previous and give me that date.
>
> Basically i have a job to set up a time table for meetings, i want to
> be able to put in any date then below it will tell me the date i need
> to send out agendas which will usually be 2 weeks before the meeting.
>
> I hope this makes sence and someone can help!
>
> Thanks
> Natalie
>
>
> --
> natys
> ------------------------------------------------------------------------
> natys's Profile:
http://www.excelforum.com/member.php...o&userid=33454
> View this thread: http://www.excelforum.com/showthread...hreadid=532609
>