Question Question for the Excel Gurus

[Texun]

I have a simple column spreadsheet (sample below) where employees add daily data and I need the spreadsheet to automatically show the monthly totals at the EOTM. Manually it's a simple =sum, but I prefer them to remain hidden and auto fill after the month has ended.

I thought this would be simple and maybe I'm overthinking something, but I've tried variations of =sum, =if, now, and a couple others but have not made much progress.




Any help would be appreciated.
Thanks and Happy New Year!

 

[Lost_in_the_HTTP]

Maybe a Macro to trigger on that date?

Is that possible?

 

[CluelessOne]

Define range as table and auto sum it.
Otherwise use EOM (end of month) function with an AND check if it is the last entry for the month.

 

[mpo]

You could try something like this in cell B9
=if(today()>$A$9,SUM(B2:B8),"Month not finished")

Not elegant, you have to define the last day of the month for each month.

 

[Texun]

You could try something like this in cell B9
=if(today()>$A$9,SUM(B2:B8),"Month not finished")

Not elegant, you have to define the last day of the month for each month.

Thank you. I'll take a swing at it tomorrow at work. I just need it to work and elegance isn't that important. I'd try an abacus if I thought it would work.

Really do appreciate the tip.

 

[CluelessOne]

To find out end of month date use EOMONTH function. So modify that formula by DAY(EOMONTH(start date, months))
See the Microsoft explanation.