Hi i am trying for a way to work out how i can formulate the date, ie.
if today is 17 November 2003, i want to import data from date 1
Novemeber 2003 how would i do this and what formulae would i use?

any idea

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

=today()-1

GB

"jaggosai" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Hi i am trying for a way to work out how i can formulate the date, ie..
> if today is 17 November 2003, i want to import data from date 16
> Novemeber 2003 how would i do this and what formulae would i use?
>
> any ideas
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>