View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Bondi
 
Posts: n/a
Default any auto formula changing 1 - 31st everyday & multiply $975


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