Counting day duration

Hi,

I understand by using =DAYS360(D2,E2), I'm able to get the duration of days from start date and end date. But when I key in start date and end date on the same day, it return 0 day

I wanted to know if there is other function that i can use get 1 day, I wish to calculate the duration by days.

Thanks in advance

Try this...

=IF(D2=E2,1,DAYS360(D2,E2))

or:

DAYS360(D2,E2) +(D2=E2)

Originally Posted by Phuocam

Try this...

=IF(D2=E2,1,DAYS360(D2,E2))

or:

DAYS360(D2,E2) +(D2=E2)

Thanks for feedback. I got it for a day if I start and end on the same day but I can't get it right for the day after.

Originally Posted by etaf

So if its one day apart do you also want to count as 1

but this is an approximation
try 1/2/15 to 1/3/15
and you will get 30 days

Twelve 30day months

Thanks for you feed back.

I've attach the file with comments in the sheet. Sheet 2 will be the start page that I with

Originally Posted by etaf

so because it does not count the same day as 1 - it will always be 1 day out

=IF(C4=D4,1,DAYS360(C4,D4)+1)

now adds one day to the result

regarding the comments

no idea what this means , and not mentioned before
Was this comment for the forum here ?

It works!. Thanks for your help.

Regarding my comment, it means No sharing of the same equipment between 2 project if the same dates are selected or within range unless it is under the same booking name.

Regarding the date selection, I wish to click on the cell and a pop up date selection instead of a drop down. Is there like a function of a Perpetual Calendar with pop up?

I've create a calendar by a right click on the cell and select insert date. How can I just click on the cell and the pop up calendar appear.