Thanks to all for the help guys
I played with Max's formula some and came up with
IF(TODAY()<=DATE(YEAR(TODAY()),MONTH(TODAY()),
15),DATE(YEAR(TODAY()),MONTH(TODAY()),15),EOMONTH( TODAY(),0))
which works as does Bill's shorter one !

Thanks very much, Happy New Year, Steve










On Jan 1, 9:54*pm, "T. Valko" wrote:
Try this:

=IF(DAY(NOW())15,EOMONTH(NOW(),0),TODAY()-DAY(NOW())+15)

Format as DATE

--
Biff
Microsoft Excel MVP

"Steve" wrote in message

...



I have tried to develop a formula that returns the 15th of the month
(if today() is <= *to the 15th) and the end of the month's date (if
today() is greater than the 15th) *I need it in the mm/dd/yy format.
I have tried using text and "dd" with if statements but have not
gotten it to work. I figure the end of month date could be handled
with the *EOMONTH(TODAY(),0) *For January the dates would be either
01/15/08 or 01/31/08,
Thanks for any help you can provide, Steve- Hide quoted text -

- Show quoted text -