Figured it out, I think:

=DATE(YEAR(TODAY()),MONTH(TODAY())-(DAY(TODAY())<=15),25)

David

"Allllen" wrote:

=IF(A1-DATE(YEAR(A1),MONTH(A1),0)<=15,DATE(YEAR(A1),MONTH (A1)-1,25),DATE(YEAR(A1),MONTH(A1),25))

for a value in cell A1.
--
Allllen


"Compass Rose" wrote:

I need a formula that will enter a date in a cell based on today's date. I'll
explain.

If today's date is from the 1st of the month to the 15th of the month, I
need the 25th day of the previous month in the cell. If the date is from the
16th of the month to the last day of the month, I need the 25th day of the
present month to appear in the cell.

Examples Today's date Cell date
11/16/2006 11/25/2006
12/5/2006 11/25/2006
1/13/2007 12/25/2006

I hope I have explained clearly.

TIA
David