Import -- using relative dates in a field?

[Guest]

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

 

[Diane Poremsky [MVP]]

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

 

[Guest]

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