Auto calculating the month end
I tried to explain that to someone in the office a while back and they just
didn't quite click in to it. I changed my explanation to the first minus 1
and the light bulb came on. Personally I use the 0 thing but I have never
tried to explain it since. I guess the 0th day of the month was a bit too
conceptual...
--
HTH...
Jim Thomlinson
"Dave Peterson" wrote:
Or even
=date(2007,10,0)
The zeroeth day of the next month is the last day of the previous month.
Jim Thomlinson wrote:
My preference is to use the first of the next month minus one. Something like
this...
=DATE(2007, 10, 1) - 1
Placed in a cell gives you Sept 30th...
--
HTH...
Jim Thomlinson
"Rip1877" wrote:
I am trying to work on a template for a bi-weekly employee time sheet. I need
the dates to range from the 1st to the 15th, and then from the 16th till the
end of the month. Is there a formula that can be used so the system would
recognize the months that have 30 or 31 days?
--
Dave Peterson
|