Prev: Summing several IF's in a column.
Next: column widths keep changing in shared file
From: igbert on 14 May 2010 12:23
Is there a fuction to return the days in a given year?

Entry Return

2008 366
2010 365

Igbert

From: Brad on 14 May 2010 12:33
assume 2008 is in a2
in b2
=DATE(A2+1,1,0)-DATE(A2,1,0)

Success - click yes.
--
Wag more, bark less


"igbert" wrote:

> Is there a fuction to return the days in a given year?
>
> Entry Return
>
> 2008 366
> 2010 365
>
> Igbert
>
From: Ms-Exl-Learner on 14 May 2010 12:37
Assume that you are having the Year in A1. Copy and paste the below formula
in B1 cell.
=IF(A1="","",DATEDIF(DATE(A1,1,1),DATE(A1+1,1,1),"D"))

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"igbert" wrote:

> Is there a fuction to return the days in a given year?
>
> Entry Return
>
> 2008 366
> 2010 365
>
> Igbert
>
From: Dave Peterson on 14 May 2010 12:35
=date(2010,1,1)-date(2009,1,1)
would give the number of days in 2009.

If you put the interested year in A1, you could use:
=date(a1+1,1,1)-date(a1,1,1)

(well, except for 1900.)

On 05/14/2010 11:23, igbert wrote:
> Is there a fuction to return the days in a given year?
>
> Entry Return
>
> 2008 366
> 2010 365
>
> Igbert
>
From: igbert on 14 May 2010 12:51
Thanks, formula works preferct for any year.


"Brad" wrote:

> assume 2008 is in a2
> in b2
> =DATE(A2+1,1,0)-DATE(A2,1,0)
>
> Success - click yes.
> --
> Wag more, bark less
>
>
> "igbert" wrote:
>
> > Is there a fuction to return the days in a given year?
> >
> > Entry Return
> >
> > 2008 366
> > 2010 365
> >
> > Igbert
> >
 |  Next  |  Last
Pages: 1 2 3
Prev: Summing several IF's in a column.
Next: column widths keep changing in shared file