Date Arithmetic

  • Thread starter Thread starter Curtis Croulet
  • Start date Start date
C

Curtis Croulet

I want to calculate the number of days between two dates by telling it to
subtract the date in (say) a2 from the date in A1. It's easy in Quattro Pro
(glad I still have it). But I can't find any way to do it in Excel 2000. Is it
possible? How? All of the date functions that I see require a date to be
entered into a formula as a literal between quotes.
 
Hi Curtis!

=A1-A2

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top