=A3-A2

no need for the Analysis Toolpak.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jeda67" <[email protected]> wrote in
message news:[email protected]...
>
> Hi All,
>
> I am trying to figure out a formula for the following:
>
> I want a blank calculation spreadsheet so I can calculate the number of
> days from two different dates it will never be over 365 days.
> My spreadsheet will have in one cell START DATE (A2) and END DATE (A3)
> and then I want the number of days to come up say in TOTAL (A4) so
> what would be the formula =?????????(A2,A3) I have seen the =360DAYS()
> formula and I don't think this is the right one!!!!
>
> I would really appreciate some help.
>
> Thanks
>
>
> --
> jeda67
> ------------------------------------------------------------------------
> jeda67's Profile:
http://www.excelforum.com/member.php...o&userid=26781
> View this thread: http://www.excelforum.com/showthread...hreadid=400387
>