Excel function to determine how many days in year YYYY

[CD2017]

Hello,

I need to determine whether my daycount should be 365 or 366 depending on the year. For example in 2016 it was 366 and in 2017 it's 365.

Is there a function which will do this?

Thanks,
Clare

 

[CD2017]

I should have said. There will be a cell containing the year 2016, and I want a formula to determine how many days are in that year.

Thanks![

QUOTE=CD2017;4821450]Hello,

I need to determine whether my daycount should be 365 or 366 depending on the year. For example in 2016 it was 366 and in 2017 it's 365.

Is there a function which will do this?

Thanks,
Clare[/QUOTE]

 

[Scott T]

Try where E1 has the year

=DATE(E1,12,31)-DATE(E1,1,1)+1

 

[Dave Patton]

Excel 2010
	E	F
1	2016	366
2		TRUE
3		366
4
3d

Cell Formulas
Range	Formula
F1	=DATE(E1,12,31)-DATE(E1,1,0)
F2	=DAY(DATE(E1,3,0))=29
F3	=365+(DAY(DATE(E1,3,0))=29)

 

[cerfani]

delete post

 

[Marcelo Branco]

Excel 2010

	E	F

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]2016[/TD]
[TD="align: right"]366[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"]TRUE[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]366[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

3d​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F1[/TH]
[TD="align: left"]=DATE(E1,12,31)-DATE(E1,1,0)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F2[/TH]
[TD="align: left"]=DAY(DATE(E1,3,0))=29[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F3[/TH]
[TD="align: left"]=365+(DAY(DATE(E1,3,0))=29)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Just a warning
https://support.microsoft.com/pt-br...tly-assumes-that-the-year-1900-is-a-leap-year

M.

 

[Marcelo Branco]

I suggest this formula
=IF(MOD(E1,100)=0,IF(MOD(E1,400)=0,366,365),IF(MOD(E1,4)=0,366,365))

M.