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