# working formula for =SUM(H37/"current day (19)" * days in the month (this month has 31) [closed] 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.

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2020-08-11 13:07:31.967817

1

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.

Sort by » oldest newest most voted

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.

more