Excel 2002: How to make a date run for a month only ?
 

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

Excel 2002: How to make a date run for a month only ?
 

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

Excel 2002: How to make a date run for a month only ?
 

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

Excel 2002: How to make a date run for a month only ?
 

On Wed, 19 Mar 2008 05:46:01 -0700, Mr. Low
wrote:

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

It would be helpful if you would post the formula you are actually using.
--ron

Excel 2002: How to make a date run for a month only ?
 

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 -

Excel 2002: How to make a date run for a month only ?
 

Hello Roger,

Thanks for your reply.

Actually I want only one cell to update itself from first day of the month
to the last day of the month.

Eg: on 1.2.2008

A
1 1/2/2008

On 2.2.2008
A
1 2/2/2008


On 29.2.2008
A
1 29/2/200


On 5.3.2008
A
1 29/2/2008

The date changes automatically as the day passed by but end at the last day
of the month.

I hope you can get what I mean.

Thanks

Low

--
A36B58K641


"Roger Govier" wrote:

Hi

No/t 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