Hi excel users,

I'm trying to work on a simple calculation which i cannot figure out the
formula.

Let's say in this column i have: 1 * $975 = $975

How can i make the "1" automatically changes to 2,3,4,5, and to the end of
the month 30th/31st, so that the the figure will be auto calculated adding
each day:
2 * $975 = $1950

Thanks in advance!!
Regards,
Kelly

Hi Kelly,

Not sure if this is what you are looking for but this will give you the
day of the month:

=DAY(TODAY())

So maybe you can use

=DAY(TODAY())*975

Regards,
Bondi

Hi Bondi,

Appreciate with the formula a lot, is it possible to add in the word "day /
days" to the number too which is running each day?

because the whole thing suppose to show (1 day x $975), but the formula you
gave is now in separate column. so i need to add the word "day" to show the
meaning.

Best Regards,
Kelly

"Bondi" wrote:

Hi Kelly,

Not sure if this is what you are looking for but this will give you the
day of the month:

=DAY(TODAY())

So maybe you can use

=DAY(TODAY())*975

Regards,
Bondi

Hi Kelly,

Maybe you can use something like this:

=DAY(TODAY())&" days x $975 = "&DAY(TODAY())*975

Regrads,
Bondi

Yes, this one works out perfectly!!!

Thanks for the help.

"Bondi" wrote:


Hi Kelly,

Maybe you can use something like this:

=DAY(TODAY())&" days x $975 = "&DAY(TODAY())*975

Regrads,
Bondi

Hi Bondi,

I wonder if you can also help me, for this formula, is there any way to make
it stop counting the days when it stop on the 30th or 31st of the month?

As at the end of the month, i need the total figure to be there too.

Best regards,
Kelly

"Bondi" wrote:


Hi Kelly,

Maybe you can use something like this:

=DAY(TODAY())&" days x $975 = "&DAY(TODAY())*975

Regrads,
Bondi

Kelly Lim wrote:
Hi Bondi,

I wonder if you can also help me, for this formula, is there any way to make
it stop counting the days when it stop on the 30th or 31st of the month?

As at the end of the month, i need the total figure to be there too.

Best regards,
Kelly

Hi Kelly,

How do you intend to use the formula?
Is it one cell for each month ot the year or shall the same cell be
used for different months?
Can you give an example?

Regards,
Bondi

Hi Kelly

I'm not sure what you are trying to achieve, but if you have the
Analysis Toolpak loaded ToolsAddinsAnalysis Toolpak, then
=IF(DAY(TODAY())=DAY(EOMONTH(TODAY(),0)),TRUE,FALS E)
will test whether today is the last day of the month.
Maybe you can incorporate this into your formula.
--
Regards

Roger Govier


"Kelly Lim" wrote in message
...
Hi Bondi,

I wonder if you can also help me, for this formula, is there any way
to make
it stop counting the days when it stop on the 30th or 31st of the
month?

As at the end of the month, i need the total figure to be there too.

Best regards,
Kelly

"Bondi" wrote:


Hi Kelly,

Maybe you can use something like this:

=DAY(TODAY())&" days x $975 = "&DAY(TODAY())*975

Regrads,
Bondi

Hi Kelly,

If the data starts in row 2, enter the formula

=(ROW()-1)*975

and drag down as far as required.

If, say, column A contains the dates for each day, try the formula:

=DAY(A2)*975

and, again, drag down as far as the last date.


---
Regards,
Norman


"Kelly Lim" <Kelly wrote in message
...
Hi excel users,

I'm trying to work on a simple calculation which i cannot figure out the
formula.

Let's say in this column i have: 1 * $975 = $975

How can i make the "1" automatically changes to 2,3,4,5, and to the end of
the month 30th/31st, so that the the figure will be auto calculated adding
each day:
2 * $975 = $1950

Thanks in advance!!
Regards,
Kelly

Hi Kelly

Try
=DAY(TODAY())*975


--
Regards

Roger Govier


"Kelly Lim" <Kelly wrote in message
...
Hi excel users,

I'm trying to work on a simple calculation which i cannot figure out
the
formula.

Let's say in this column i have: 1 * $975 = $975

How can i make the "1" automatically changes to 2,3,4,5, and to the
end of
the month 30th/31st, so that the the figure will be auto calculated
adding
each day:
2 * $975 = $1950

Thanks in advance!!
Regards,
Kelly