Display a date in autofill if there’s a 31st in the month
I’m making a spreadsheet that has an autofill date column that will be generic for all months, so there will be 31 days. However I do not want it to …
DATE
How do I extract the date if the given data are: 1) Week ending date 2) Days of the week (for which the exact date falls into) See example below: …
Sumproduct Name and Date criteria
Hello guys, i need help calculatin how much money has been paid for a specific transport company for a certain month. For example sum the last columnt if the …
Changing Excel Cells Colour Based on Date
I have a skills matrix for employees that I wish to add a formula to in order to warn us when certain certificates for skills expire. I currently have the …
If statement between times and days
Hi everyone, I’m trying to create a formula for my overtime, as I get a different pay rate at different days and times. Mon – Fri: 17:00 – …
Daily Balance Sheet
I need a workbook to keep up with cash paid out and received daily. I would like to have multiple sheets for each month (example – dec. 1st, dec. 2nd, …
Return a certain cell value if corresponding date.
Okay, So I am trying to return a certain cell value if todays date is within two weeks. I have a paycheck and hour tracker, and there is a total hours value …
Vlookup with Today() formula
The first table is the input table. The second table is the for the results. The result should display as follow: – If the end date of the …
Accountant
Hi I am working on an Excel 2007 workbook within which there are 9 worksheets. In particular, there is 1 worksheet which is giving me trouble. There is a row …
Sorting Extensive Dates and Times
Everyday I pull up a report indicating when someone took a course for my work. Instead of pulling up in chronological order, the report shows the Day of the …
Change chart horizontal axis to Date
Im using Excel 2010 for MAC. I have a stacked bar chart. The horizontal (value) axis consists of dates. They are in date format in the spreadsheet. On the …
Trouble in format
I am totally new to excel.So I guess I am missing something very basic here.The problem is whenever I am making an input such as 1.2 or 2.3 in a cell,excel …