I am trying to add up daily totals in a worksheet, but how do I do that when
some months have 30 days, and some have 31, not to mention Feb. that has only
28. Also, I need to subtract the first day of the new month from the last
day of the previous month, is there a formula for that, or how do I do that?

Any help will be greatly appreciated. Thank you.

Can you describe how your data is structured?
For example, are there dates in Col_A?
Where do you want the totals to appear?

***********
Regards,
Ron

XL2002, WinXP


"p-nut" wrote:

I am trying to add up daily totals in a worksheet, but how do I do that when
some months have 30 days, and some have 31, not to mention Feb. that has only
28. Also, I need to subtract the first day of the new month from the last
day of the previous month, is there a formula for that, or how do I do that?

Any help will be greatly appreciated. Thank you.

The data is in column A, then the total is then showed in column B

"Ron Coderre" wrote:

Can you describe how your data is structured?
For example, are there dates in Col_A?
Where do you want the totals to appear?

***********
Regards,
Ron

XL2002, WinXP


"p-nut" wrote:

I am trying to add up daily totals in a worksheet, but how do I do that when
some months have 30 days, and some have 31, not to mention Feb. that has only
28. Also, I need to subtract the first day of the new month from the last
day of the previous month, is there a formula for that, or how do I do that?

Any help will be greatly appreciated. Thank you.

Just for clarification....

Is the data something like this?
Sheet1
Col_A Col_B
date1 Amt1
date2 Amt2
date3 Amt3
date4 Amt4
date5 Amt5

Would the totals be on Sheet2?
Col_A Col_B
Month1 TotalMth1
Month2 TotalMth2

***********
Regards,
Ron

XL2002, WinXP


"p-nut" wrote:

The data is in column A, then the total is then showed in column B

"Ron Coderre" wrote:

Can you describe how your data is structured?
For example, are there dates in Col_A?
Where do you want the totals to appear?

***********
Regards,
Ron

XL2002, WinXP


"p-nut" wrote:

I am trying to add up daily totals in a worksheet, but how do I do that when
some months have 30 days, and some have 31, not to mention Feb. that has only
28. Also, I need to subtract the first day of the new month from the last
day of the previous month, is there a formula for that, or how do I do that?

Any help will be greatly appreciated. Thank you.

yes, and then what about the months that have 30 or 28 days?

"Ron Coderre" wrote:

Just for clarification....

Is the data something like this?
Sheet1
Col_A Col_B
date1 Amt1
date2 Amt2
date3 Amt3
date4 Amt4
date5 Amt5

Would the totals be on Sheet2?
Col_A Col_B
Month1 TotalMth1
Month2 TotalMth2

***********
Regards,
Ron

XL2002, WinXP


"p-nut" wrote:

The data is in column A, then the total is then showed in column B

"Ron Coderre" wrote:

Can you describe how your data is structured?
For example, are there dates in Col_A?
Where do you want the totals to appear?

***********
Regards,
Ron

XL2002, WinXP


"p-nut" wrote:

I am trying to add up daily totals in a worksheet, but how do I do that when
some months have 30 days, and some have 31, not to mention Feb. that has only
28. Also, I need to subtract the first day of the new month from the last
day of the previous month, is there a formula for that, or how do I do that?

Any help will be greatly appreciated. Thank you.

Also, what I am wanting to do is subtract column B4 from column B5 with the
total in column C5. Does that clear things up?

"Ron Coderre" wrote:

Just for clarification....

Is the data something like this?
Sheet1
Col_A Col_B
date1 Amt1
date2 Amt2
date3 Amt3
date4 Amt4
date5 Amt5

Would the totals be on Sheet2?
Col_A Col_B
Month1 TotalMth1
Month2 TotalMth2

***********
Regards,
Ron

XL2002, WinXP


"p-nut" wrote:

The data is in column A, then the total is then showed in column B

"Ron Coderre" wrote:

Can you describe how your data is structured?
For example, are there dates in Col_A?
Where do you want the totals to appear?

***********
Regards,
Ron

XL2002, WinXP


"p-nut" wrote:

I am trying to add up daily totals in a worksheet, but how do I do that when
some months have 30 days, and some have 31, not to mention Feb. that has only
28. Also, I need to subtract the first day of the new month from the last
day of the previous month, is there a formula for that, or how do I do that?

Any help will be greatly appreciated. Thank you.

I still need more information...Please bear in mind that while you can see
your data, we on the newsgroup cannot. Providing more details will result in
better, more tailored responses.

Does Col_B contain YTD totals? MTD totals? Daily totals?
Why do you want to subtract the previous day's amount from the current day's
amount?...to calculate each day's activity?

Are you really interested in calculating Daily totals or do you think you
need them to calculate monthly activity?

***********
Regards,
Ron

XL2002, WinXP


"p-nut" wrote:

Also, what I am wanting to do is subtract column B4 from column B5 with the
total in column C5. Does that clear things up?

"Ron Coderre" wrote:

Just for clarification....

Is the data something like this?
Sheet1
Col_A Col_B
date1 Amt1
date2 Amt2
date3 Amt3
date4 Amt4
date5 Amt5

Would the totals be on Sheet2?
Col_A Col_B
Month1 TotalMth1
Month2 TotalMth2

***********
Regards,
Ron

XL2002, WinXP


"p-nut" wrote:

The data is in column A, then the total is then showed in column B

"Ron Coderre" wrote:

Can you describe how your data is structured?
For example, are there dates in Col_A?
Where do you want the totals to appear?

***********
Regards,
Ron

XL2002, WinXP


"p-nut" wrote:

I am trying to add up daily totals in a worksheet, but how do I do that when
some months have 30 days, and some have 31, not to mention Feb. that has only
28. Also, I need to subtract the first day of the new month from the last
day of the previous month, is there a formula for that, or how do I do that?

Any help will be greatly appreciated. Thank you.

My example is this:

date meter read. usage

1 123455 111111
2 234566 111111
3 345677

I am needing to calculate daily totals, and then at the end of the month
calculate a monthly total. Also, I am needing to keep track of usage from
the 15th of one month to the 15th of the next month.

I am so sorry that I haven't been able to be any clearer, I am very new to
this.
"Ron Coderre" wrote:

I still need more information...Please bear in mind that while you can see
your data, we on the newsgroup cannot. Providing more details will result in
better, more tailored responses.

Does Col_B contain YTD totals? MTD totals? Daily totals?
Why do you want to subtract the previous day's amount from the current day's
amount?...to calculate each day's activity?

Are you really interested in calculating Daily totals or do you think you
need them to calculate monthly activity?

***********
Regards,
Ron

XL2002, WinXP


"p-nut" wrote:

Also, what I am wanting to do is subtract column B4 from column B5 with the
total in column C5. Does that clear things up?

"Ron Coderre" wrote:

Just for clarification....

Is the data something like this?
Sheet1
Col_A Col_B
date1 Amt1
date2 Amt2
date3 Amt3
date4 Amt4
date5 Amt5

Would the totals be on Sheet2?
Col_A Col_B
Month1 TotalMth1
Month2 TotalMth2

***********
Regards,
Ron

XL2002, WinXP


"p-nut" wrote:

The data is in column A, then the total is then showed in column B

"Ron Coderre" wrote:

Can you describe how your data is structured?
For example, are there dates in Col_A?
Where do you want the totals to appear?

***********
Regards,
Ron

XL2002, WinXP


"p-nut" wrote:

I am trying to add up daily totals in a worksheet, but how do I do that when
some months have 30 days, and some have 31, not to mention Feb. that has only
28. Also, I need to subtract the first day of the new month from the last
day of the previous month, is there a formula for that, or how do I do that?

Any help will be greatly appreciated. Thank you.