15th

Excel 2007 I have this code =IF(DAY(A1)<=15,DATE(YEAR(A1),MONTH(A1),15),EOMONTH(A1,0)) The issue I have is the every other row in a range CH6:CH1000 show the date for the month and day and the other row has #VALUE! After thought, what I really want to do is in column CH6:CH1000 every row...

I have an invoice built in Excel. On that sheet I have a start date (cell M11) that is formatted as a Date in the mm/dd/yy format. I have another cell (M42) that I need to enter a formula so that if the day in M11 is before the 15th it add 2 months or if the day is equal to or later then that...

HI, Trying to see if this possible. I have so many different sheets. I need something to change the 15th of every month Right now i have this =Sheet2!C4 So on November 15th i need it to pull this =Sheet2!C5 Dec 15th =Sheet2!C6 Only this change would be the number. Possible?

Hello, I am trying to figure out the formula for the following: Starting in G2 I want to add a 1 when the dates in C2 and D2 are within the range of G1 and continue on for each cell down and across. The formula I have now does that. However, I cant figure out how to make a formula where: Add a...

Hi everyone! How are you Doing? Hope everything is fine. Dear friends, Where I am working, every employee have a total of 15 days of vacations after each year of work. But after each 3 years of work, they add one more day per year. So let me illustrate that in a clearer example: Let's take...