Can I set it up as an IF function? Like if the date<=15 then it uses the
15th, IFdate=16 then =eomonth(a1,0) ?

What I want to do is set it up so it will input the end of a pay period as
either the 15th or the end of the month. depending on if it is the first or
second pay period.

Can I use the IF function for that and if so, what would the formula need to
look like?

"Gary Keramidas" wrote:

go to tools/addins and check analysis toolpak and install it if it isn't already
installed. you will probably need the o2k3 cd.
with a date in a1
enter in b1
=eomonth(a1,0)
will give you the last day of the month in cell a1

--


Gary