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


--
natys
------------------------------------------------------------------------
natys's Profile: http://www.excelforum.com/member.php...o&userid=33454
View this thread: http://www.excelforum.com/showthread...hreadid=532609

Changing dates using a formula
 

=A1-14

assuming your date is in A1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"natys" wrote in message
...

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