=DAYS360 Function

  • Thread starter Thread starter PBR
  • Start date Start date
P

PBR

Is there a way to manipulate this function so that it
will count a 366 day year? I'm trying to calculate tax
prorations and this would certainly be helpful!

Thanks,
Philip Rose
 
Hi PBR!

From what you say, I think you're looking at the wrong function.

To count the number of days in a year:

With a year number in A1 use:

=DATE(A1+1,1,1)-DATE(A1,1,1)

Or a neat one by Daniel M

=337+DAY(DATE(A1,3,))

(Adds day number of the last day of February to the sum of the days in
all other months).

With a date in A1

=DATE(YEAR(A1)+1,1,1)-DATE(YEAR(A1),1,1)

Or:

=337+DAY(DATE(YEAR(A1),3,))
 
Back
Top