Hi

Not sure whether I am interpreting your request correctly.

Assuming your start date for the month is in cell A1
in cell A2 enter
=IF(MONTH(A1+1)MONTH(A1),"",A1+1)
Copy down through cells A3:A31

If you enter 01 Jan 08 in A1, all 31 cells will be filled.
If you enter 01 Feb 08 in A1, cells A30 and A31 will be blank

--
Regards
Roger Govier

"Mr. Low" wrote in message
...
Dear Sir,

May I know how to make a date run within a cell on daily basis up to the
last day of the month using Excel formulas ?

I used =TODAY( ) , but it runs beyond at the last day of the month.

I would be glad if you could help me on this.


Thanks

Low




--
A36B58K641