Discussion Locked

calculate days between months

0 helpful

3 replies

by Member 31688719 May 31, 2005 last reply Jan 4, 2006

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I need to know how to calculate the number of days between 01/02/2005 and 31/05/2005 using excel.

3 replies

DATEDIF(start_date,end_date,unit)

start_date and end_date can be relative cells as well.

Do not know how accurate it is but i find the DAYS360 a handy function.

e.g =Days360(A2,B2,false)

Where the cell A2,B" are cell references

Learn how here.

Lee

This discussion is closed to new replies.