Import -- using relative dates in a field?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike B - 16 Sep 2007 19:30 GMT

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

Reply to this Message

Diane Poremsky [MVP] - 17 Sep 2007 12:58 GMT

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

Signature

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:
dailytips-subscribe-request@lists.outlooktips.net

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

>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
[quoted text clipped - 15 lines]
>
> Mike

Reply to this Message

Mike B - 17 Sep 2007 13:06 GMT

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

> you'd have use a formula in the excel fields to calculate dates.
>
[quoted text clipped - 17 lines]
> >
> > Mike

Reply to this Message