Please enable JavaScript to view the comments powered by Disqus.


N(...A1-EOMONTH(...A1,-MONTH(...A1)))

How to count days passed for a year.

The formula counts days from the start of the year till the end that is specified and gives the day count. 


Used Functions

Category: Information

Returns a value converted to a number

Syntax

N(value)

Category: Date and time

Returns the serial number of the last day of the month before or after a specified number of months

Syntax

EOMONTH(start_date, months)

Category: Date and time

Converts a serial number to a month

Syntax

MONTH(serial_number)

Lets chat on this