daily calculations

[Guest]

I am trying to run a spreadsheet of daily calculations and I am having
trouble setting up the formulas. Here is an example of what I am trying to
do:

date reading usage
A B C
1 12345 11111
2 23456 11111
3 34567
4
31 56789
Then I am wanting to take the number that I put in the 1st for the new
month, to subtract the 31st to get the usage for that day.My delema is that I
can't figure out how to set up the formula to subtract the last day of the
month from the first of the next month. Since some months have 31 days, some
with 30, and the dreaded 28 of February.

I am very new at this type of thing, so if there is any need of more
information, please let me know.

Thank you for any help.

 

[Biff]

Hi!

The reason you're not getting any replies (several posts over the last few
days) is because nobody can understand what you want!

You want to subtract the last reading of a month from the first reading of
the new month. OK, that makes sense and sounds easy enough. However, based
on your posted sample where is the reading for the new month?

Biff

 

[Earl Kiosterud]

p,

I'm not sure what the day (col A) has to do with anything. You don't show
where the next first-of-the-month goes. Does it continue after the last day
of the current month? If so, just in C2, you'd have =B2-B1. Copy that
down with the Fill Handle. Otherwise, tell us explicitly what you have. No
assumptions. Give examples.