MrExcel Publishing
Your One Stop for Excel Tips & Solutions

number of days between two dates


Posted by TB on January 10, 2002 12:55 PM

hey all.

someone recently posted something similar, but i just want to find the number of days between two dates. nothing having to do with TODAY() or anything current like that. i just discovered that my spreadsheet is using the DAYS360() function...but i want it based on an actual 365 day calendar year!

any help would be...ummm...helpful.

TB


Posted by Juan Pablo G. on January 10, 2002 1:23 PM

How about a simple

=B1 - A1

?

Format as General.

Juan Pablo G.

Posted by IML on January 10, 2002 1:25 PM

You can simply use:
=A2-A1
where the earlier date is in A1.

You will get a weird looking date which will disappear after you change the cell format to "general"

good luck