Ask Your Question

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

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

n6nicg gravatar image

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



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.

Lupp gravatar imageLupp ( 2017-12-19 23:31:56 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-12-19 23:41:58 +0200

Lupp gravatar image

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.

edit flag offensive delete link more


That worked, thank you very much!

n6nicg gravatar imagen6nicg ( 2017-12-22 19:27:30 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 24 times

Last updated: Dec 19 '17