Date Arithmetic

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.
 
N

Norman Harker

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding Date Formula 0
countifs Function not giving desired result with date criteria 2
Calculate elapsed time excluding specific timeframe 10
Calculate end date and time 1
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Subtracting time...again 2
IF AND Function Date Range Issues 6
Calendar Logic: Recurring Dates 3

Top