I am trying to add up numbers for each day of the week, and I can't figure
out how to set it up so that if the month only has thirty days, that I don't
have to add a number in the 31st. Also, what is the function so that I can
subtract the last day from the first? Please help.

Hi p-nut,

Your question is not very clear to me, but this formula allocates a number
to the day, Jan 1th = 1, Jan 2th = 2... Dec 31th = 365/366.

DAYS360(A1;38718)

Cell A1 contains the actual day, 38718 = Jan 1th, 2006.

Your second question, use the ordinary subtract function.



--
~roar


p-nut skrev:

I am trying to add up numbers for each day of the week, and I can't figure
out how to set it up so that if the month only has thirty days, that I don't
have to add a number in the 31st. Also, what is the function so that I can
subtract the last day from the first? Please help.