Total number of days in current year

[Anonymous]

Hi.

Is there a way of getting the total number of years in the year we are in now? So that i can figure out if the current year is a leap year or not.

[MK_QSL]

=Interval(YearEnd(Today()) - YearStart(Today()),'dd')

or

=IF(Interval(YearEnd(Today()) - YearStart(Today()),'dd')>=365,'Leap Year', 'Not a Leap Year')

or

=IF(FLOOR(YearEnd(Today())) - FLOOR(YearStart(Today()))=365,'Leap Year','Not a Leap Year')

[Anonymous]

I get 364 as output from:
=Interval(YearEnd(Today()) - YearStart(Today()),'dd')

[#4]

Hi,

to get the number of days in current Year use this expression

=floor(Num(YearEnd(Today()))-Num(YearStart(Today()))) + 1

[MK_QSL]

Check my other replies also...

[CELAMBARASAN]

Hi,

We can decide the Leap Year, based on the year itself.

=If((Mod(vYear, 100) and not Mod(vYear, 4)) or not Mod(vYear, 400), 'Leap Year', 'Not a Leap Year' )

Where vYear is variable equals some number like 2012 or expression like Year(Today())