Number of days from given date

[Salamullah]

Dear Exparts,

I want to apply formula to calculate number of days for this date 30/06/2011 How can I do this ?

 

[Sektor]

=day(a1)

 

[Salamullah]

Thanks but giving following

<TABLE style="WIDTH: 61pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=81 border=0 x:str><COLGROUP><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2304" width=81><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl174 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 61pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" width=81 height=21 x:err="#VALUE!">#VALUE!</TD></TR></TBODY></TABLE>

 

[Sektor]

Then your date isn't a date.

 

[Yahya]

Try this if your data not real date

=DAY(DATEVALUE(A1))