sept

Hi My computer date/clock is DD-MM-YYYY. So I tried to enter the following. I understand all except 3rd and the 5th (the last) rows. Why Excel accepted yyyy-m-dd as a date and why accepted sept 14, 2019 as a date and changed to 14-sept-2019. but why did not change it to 14-09-2019 (why 09...

Hi My computer date/clock is DD-MM-YYYY. So I tried to enter the following. I understand all except 3rd and the 5th (the last) rows. Why Excel accepted yyyy-m-dd as a date and why accepted sept 14, 2019 as a date and changed to 14-sept-2019. but why did not change it to 14-09-2019 (why 09...

Hi All, I am new to Excel so apologies if my question will miss pieces of information or is not clear. We work within the Construction Industry and make monthly projections of our turnover based on prospect. BACKGROUND We assume based on the size of the fee - which is related to the size of...

Good morning I have a workbook which has 9 individual Dept sheets to record travel costs. I am looking for help in calculating the total monthly cost on each sheet and transfering that figure into the correct month on the summary sheet. <colgroup><col width="64" style="width:48pt" span="7">...

Hello, I need some help with my data with different months across a financial year. I want to pull out ending month data, so where the date changes from one month to another eg. Sept - Oct - different month so pick the ending value shown in the column, else 0. The idea is that I want the...

I am in need of a formula that will allow me to flag if they have a balance within a +-$1.00 range: For instance- Month: Client: Account Balance: August Bob 10.01 August Lucy 11.27 August Sam 9.56 Sept Bob...

Is this possible to insert an apostrophe between the month and year (replacing the date with an apostrophe) using the custom format dialog box For Example: Is it possible to format Sept 1, 2018 in a cell to display Sept '18. When I've done this in the past I've had to manually type this...

I am trying to create a running calendar for a team. There are 7 team members (Jeremy, Ben, Nate, Matt, Harry, Logan, Team 7) dates, and 3 statuses (Training, Deployed, Leave) I made two sheets: 1st with the raw data (Date, Name, Status) and the second sheet with the yearly calendar. I want the...

Hello MrExcel'ers So I've been asked by my boss to put a project managers hat on, to build a gantt chart. I don't have Project Installed so I'm relying on good old excel I've provided an image view to show you want I'm after which in summary is to HIGHLIGHT (Column S:AA) based on a month...

I have a date ranges as per below. one range per cell. in the next column i have month and year from any of the below ranges. i.e Oct 2019 I need to count occurrence of of Oct 2019 in the third column in the row corresponding with the actual range, which is Oct - Dec 2019...

I am looking for the best way to create a list of home fixtures for a specific date (this will help me to see book a pitch at certain times), which will show me the team that's playing at home and the kick off time. The home team will always be a 'Weedon' Team I have 6 age groups and have all...