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
1	2016	366
2		TRUE
3		366
4

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

3d​

Worksheet Formulas Cell 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) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

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.