I can do the basic formula =SUM(H37/19*31) [what the formula is today] but i don’t know how to make it automatic with the current day and month.
What do you expect the formula =SUM(H37/DAY(TODAY))*DAYSINMONTH(TODAY()))
to achieve? What is the call to the SUM() function supposed to be useful for? In other words: Why not simply =H37/DAY(TODAY))*DAYSINMONTH(TODAY())
?
Isn’t there any cell in the sheet already providing the result of TODAY()? Would make the formula more simple and clear. Probably use a spare cell for this and reference it in the formula.
Suppose A2 is containing the formula =TODAY()
.
Put =H37/DAY($A$2)*DAYSINMONTH($A$2)
in the cell where you want to get the result.
That worked, thank you very much!