eom

Hello, I am sorting my accounting spreadsheet and using the formula IF(J4="30EOM",EOMONTH(C4,0)+30) which works, the problem I have is adding more If variables for this file, most customers are 30 days EOM, but some are 45 EOM, some are just 30 days, some are 60 days. If I can get the first...

Hello, I have a facility where their workweek is Monday through Saturday an I need to be able to determine which day of the month will be the last workday, EOM. I'm currently using this formal for a normal 5-day workweek "=IF(WORKDAY(EOMONTH($L$2,0)+1,-1,holidays)=AJ2,"EOM","")". I did some...

I have written a formula that looks in up to 31 tabs (designed to fit a monthly schedule) looking for values. Problem is, by the time I get to the 30th and 31st... the formula is way too long. I can always truncate the formula and put a second portion elsewhere but I would prefer to keep it...

With conditional formatting, how do I flag a value in terms of calendar months? ie. I want to flag any cell with a date over 6 calendar months old: 01/17/2017 would flag on 07/31/2017, 08/03/2017 would flag on 02/28/2018. Thanks!

Hello, I'm hoping someone can assist me, I need to have a formula that calculates when the last workday of the month is, holidays would not be counted as work days. I then need for "EOM" to appear in the column representing the last working day of the month. Currently I have this formula that...