YouTubersLoveExcel#22: EOM Terms with IF, DAY & EOMONTH fun

I have a long list of websites and I want to know if any of them fall within a single complicated url. So is there a function where I can ask something like... are any of these items in this list, in this single complicated string? I can't parse the url's as they are not all www.etc...

Thanks,

Brad

Hello. This is probably simple, however, I've tried several options and can't get this to work. My macro needs to walk down a list of dates (column A) and evaluate the date: if the date is an end of month (EOMONTH) date, then offset and copy data, if not, then ignore the line and move to the next date (row) for evaluation. Any thoughts?

Hi,

For some bizarre reason my EOMONTH() function in Excel has stopped working. I'm getting a #NAME? error.

Surely this should not happen with excel functions?

Does anyone know why this would happen?

I can use EOMonth to calcualte the last day in the current month. However, how do I modify it so that I can calculate the last Sunday for the month in question?

Here is my current formula =EOMONTH(DataDate,0). FYI, DataDate is the Sunday for the current week.

Alternatively, what I am trying to do is modify the following =INDEX($H$3:$AQ$1501,0,MATCH(DataDate,$H$2:$AQ$2,0))) so that instead of using the DataDate to get current week results I can substitute "DataDate" with something that will enable me to calculate the end of month results based on a Sunday week start.

i am not sure if this is possible to do using EOMONTH

c4 is hire date 11/3/08

11/30/2008 =EOMONTH($C$4, 0)
12/31/2008 =EOMONTH($C$4, 1)
1/31/2009 =EOMONTH($C$4, 2)
2/28/2009 =EOMONTH($C$4, 3)
3/31/2009 =EOMONTH($C$4, 4)
4/30/2009 =EOMONTH($C$4, 5)
5/31/2009 =EOMONTH($C$4, 6)
6/30/2009 =EOMONTH($C$4, 7)
7/31/2009 =EOMONTH($C$4, 8)
8/31/2009 =EOMONTH($C$4, 9)
9/30/2009 =EOMONTH($C$4, 10)
10/31/2009 =EOMONTH($C$4, 11)


the problem is that when it becomes 2010, i need to change them to current year, but the first 2 in this example must be 2009

So is it possible ?

Hi All,

am currently having problems using the EOMONTH function in excel 2003.

this is the formula that my colleague used to have and use but its working for him. when i got the file, everything went haywire!

=IF(J6="","",(EOMONTH(J6,1)))
=IF(L6="","",(EOMONTH(L6,0)))

i dont know what the issue is about

Hi - does anyone know if there is an eomonth() equivalent in VBA?

Why would an 'EOMONTH' formula in a cell suddenly stop working????

I still have the add-in loaded but can't seem to get it to work.......

Why Does excel sometimes not like to give the result for the =EOMONTH Function? I'm using anther software program to pull data from excel and when I do this EOMONTH will not work.

What Alternatives do I have to this function?

Thanks

We've developed a sheet for use as a Statement of Account to customers and it sums 0-30 days, 31-60 days, 61-90 days, 91- 120 days and over.

We're using the following formula: SUMIF($A15:$A31,EOMONTH(F3,-1),$F15:$F31) - for 0-30 days, the others are (F3,-2) etc -, where F3 is the statement date, and can be anydate, column A has the invoice dates and column F has the invoice values. We normally invoice on the last day of the month and this formula works perfectly and picks up the invoices in the correct places on the statement.

Occasionaly we invoice in the middle of the month and this formula doesn't recognise the invoices at all and returns nothing. We've tried replacing EOMonth with (>F3-30) and various other configurations, but to no avail.

Can anyone help in resolving this problem for an Excel Dummy?

Thanks