Sorry, missed a bracket out:

=IF(AND(MONTH(A1)=MONTH(TODAY()),YEAR(A1)=YEAR(TOD AY())),TODAY(),"")

Hope this helps.

Pete

On Mar 19, 12:58*pm, Pete_UK wrote:
How would Excel know which month you are talking about?

If you were to put a date in A1, for example 01/01/08, then you could
have something like this:

=IF(AND(MONTH(A1)=MONTH(TODAY()),YEAR(A1)=YEAR(TOD AY()),TODAY(),"")

Will return today's date only if it is in the same month and year as
the date in A1, otherwise it will return a blank.

Hope this helps.

Pete

On Mar 19, 12:46*pm, Mr. Low
wrote:



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- Hide quoted text -

- Show quoted text -