Posted to microsoft.public.excel.programming

Rick Rothstein $MVP - VB$ $Rick Rothstein $MVP - VB$ is offline$

external usenet poster

Posts: 2,202

Difference between two dates

Why not just this...

=ABS(B1-A1)

instead?

Rick

"Gary''s Student" wrote in message
...
if the dates are in A1 and B1, then

=MAX(A1,B1)-MIN(A1,B1)
--
Gary''s Student - gsnu200764

"tc" wrote:

hi. i need to create a macro that will alow me to find the difference
in days between two given dates. is this possible?
thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Difference between two dates	dlw	Excel Discussion (Misc queries)	1	March 3rd 10 08:15 PM
Difference between two dates	Sheeloo	Excel Discussion (Misc queries)	0	March 3rd 10 05:25 PM
Difference between dates	Khurum	Excel Worksheet Functions	12	August 13th 08 12:53 AM
Difference of two dates	Zafar	Excel Worksheet Functions	3	July 26th 07 08:44 AM
Difference of two dates	sajan chauhan	Excel Discussion (Misc queries)	3	June 5th 07 04:47 AM

All times are GMT +1. The time now is 12:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us