Rip1877,

Try the function =Date(year,month,day)


"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?