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