Hello all, wonder if anyone can help me out with this question. In
database I need to say how many weeks are left between two dates. Fo
example 21/05/04 and 31/03/05. Anyone have any ideas how to do this
Any help much appreciated

--
goonboy17
-----------------------------------------------------------------------
goonboy175's Profile: http://www.excelforum.com/member.php...fo&userid=2533
View this thread: http://www.excelforum.com/showthread.php?threadid=38810

How accurate do you want it?

You could simply subtract one from the other and divide by 7

e.g

=(A1/B1)/7

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(E-Mail Removed)HIS


"goonboy175" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> Hello all, wonder if anyone can help me out with this question. In a
> database I need to say how many weeks are left between two dates. For
> example 21/05/04 and 31/03/05. Anyone have any ideas how to do this?
> Any help much appreciated!
>
>
> --
> goonboy175
> ------------------------------------------------------------------------
> goonboy175's Profile:
> http://www.excelforum.com/member.php...o&userid=25332
> View this thread: http://www.excelforum.com/showthread...hreadid=388106
>