Import -- using relative dates in a field?
 

I love the facility in Outlook where you can enter a relative date in
words... like you might enter a date for the Due Date, and then for the Start
Date you can enter "10 days before" and it will calculate the right Start
Date 10 days before the Due Date.

You can also type in "today" and so on.

What would be nice is if you could use these sorts of "relative values" in a
spreadsheet to be imported... so you could calculate the Due Date in your
spreadsheet, and then just put "1 month before" for the Start Date and it
will work things out for you.

Is this possible in any way? Or too optimistic?

Thanks,

Mike

Import -- using relative dates in a field?
 

you'd have use a formula in the excel fields to calculate dates.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"Mike B" wrote in message
...
I love the facility in Outlook where you can enter a relative date in
words... like you might enter a date for the Due Date, and then for the
Start
Date you can enter "10 days before" and it will calculate the right Start
Date 10 days before the Due Date.

You can also type in "today" and so on.

What would be nice is if you could use these sorts of "relative values" in
a
spreadsheet to be imported... so you could calculate the Due Date in your
spreadsheet, and then just put "1 month before" for the Start Date and it
will work things out for you.

Is this possible in any way? Or too optimistic?

Thanks,

Mike

Import -- using relative dates in a field?
 

OK, thought so. I am already doing that, in fact (my existing spreadsheet is
for importing dates into Palm Desktop), but wanted to know if I could
simplify my spreadsheet somewhat by passing a lot of the burden across to MS
Outlook itself.

Mike


"Diane Poremsky [MVP]" wrote:

you'd have use a formula in the excel fields to calculate dates.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"Mike B" wrote in message
...
I love the facility in Outlook where you can enter a relative date in
words... like you might enter a date for the Due Date, and then for the
Start
Date you can enter "10 days before" and it will calculate the right Start
Date 10 days before the Due Date.

You can also type in "today" and so on.

What would be nice is if you could use these sorts of "relative values" in
a
spreadsheet to be imported... so you could calculate the Due Date in your
spreadsheet, and then just put "1 month before" for the Start Date and it
will work things out for you.

Is this possible in any way? Or too optimistic?

Thanks,

Mike