Complex sorting
I have 2 excel files that I want to merge. Each has 2 columns, one of which is dates and one of which is dollar amounts. Within each sheet, the dates are in …
Conditional modifiers for Date AND Time
I’m trying to create a formula that is conditional on both day and time. Specifically, if the current time is AFTER 1600 on a Friday and BEFORE …
change embedded date automatically
is there a way to automatically increment the date by 1 for each successive row with this as the original formula: =SUM(‘M:FY 2018 DepositsDeposit …
Automatic Date and Time Input
Would like to have computer’s current date and time automatically appear in a spreadsheet, in column A and on the next row, at each instance that a …
Convert American date to English date in dd/mm/yy hh:mm format
I have taken data from a website and the date comes in mm/dd/yy hh:mm AM/PM format however I need it in dd/yy/yy hh:mm format. I need to find out the …
assistant
I have to prepare a riport each weak and I would like to automatize it (VBA). I want to save it with the actual date of the week each week. This …
assistant
I have to prepare a riport each weak and I would like to automatize it (VBA). I want to save it with the actual date of the week each week. This …
I need an empty cell instead of date
Hi, I’ve spent all day trying to figure this out but nothing seemed to be working. Basically I have 2 lists. In the first list I have a cell with a date …
Simple date matching. Please help
Hello Below are 4 columns. ALL DATE, PRICE, MARKET OPEN and CLOSE. ALL DATE has all of the dates in the year. MARKET OPEN has dates where the stock market was …
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 …