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

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