Ask Your Question

# working formula for =SUM(H37/"current day (19)" * days in the month (this month has 31)

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 close merge delete

## Comments

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.

## 1 Answer

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

## Comments

That worked, thank you very much!

## Stats

Asked: 2017-12-19 23:03:13 +0200

Seen: 24 times

Last updated: Dec 19 '17