if you install the analysis toolpak, you can use the eomonth function.

--


Gary


"Rip1877" wrote in message
...
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?