Search code examples
datedatetimegoogle-sheetsformula

Using EOMONTH in Google Sheets considering time not just date

I have A1 showing the start of month (but can be changed) andI have A2 using EOMONTH(A1;0) to show the last date of that month selected in A1.

In my sheet I use these two cells in various formulas to populate numbers from a report that are within that time frame. However, I noticed that it doesn't consider records that are from that last date past hour 00:00:00... So basically I need it to show the last day of the month and 23:59:59... How can incorporate this in the formula EOMONTH? It needs to work smoothly based on what start date I pick in A1.

Solution

  • Add time after getting date by EOMONTH(). Try-

    =EOMONTH(A1,0)+TIME(23,59,59)