Ask Your Question

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

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

n6nicg gravatar image

updated 2020-08-11 13:07:21 +0200

Alex Kemp 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 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



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

Question Tools

1 follower


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

Seen: 26 times

Last updated: Dec 19 '17