• Home
  • Excel Formulas
  • Excel Functions
  • Excel VBA
  • Help us Answer Questions
  • Ask a Question
Home / Posts tagged Date

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 …

August 24, 2019 | Excel 2003 Help | 217 Comments

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 …

July 26, 2019 | Excel 2003 Help, Formula | 158 Comments

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 …

March 7, 2019 | Excel 2003 Help, Excel Formulas | 0 Comments

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 …

February 19, 2019 | Excel 2003 Help, Functions | 12 Comments

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 …

December 4, 2018 | Excel 2003 Help, Excel 2010 Help | 0 Comments

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 …

November 29, 2018 | Excel 2003 Help | 8 Comments

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 …

November 29, 2018 | Excel 2003 Help | 1 Comment

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 …

October 29, 2018 | Excel 2003 Help, Excel 2007 Help | 0 Comments

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 …

August 3, 2018 | Excel 2003 Help, Excel 2010 Help | 0 Comments

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 …

June 4, 2018 | Excel 2003 Help, Excel 2010 Help | 0 Comments

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:   …

June 4, 2018 | Excel 2003 Help, Excel Formulas | 5 Comments

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 …

April 2, 2018 | Excel 2003 Help, Excel Formulas | 0 Comments

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 …

March 15, 2018 | Excel 2003 Help, Excel Formulas | 12 Comments

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 – …

January 5, 2018 | Excel 2003 Help, Formula | 10 Comments

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, …

December 11, 2017 | Excel 2003 Help | 0 Comments

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 …

October 12, 2017 | Excel 2003 Help | 0 Comments

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 …

October 5, 2017 | Excel 2003 Help | 0 Comments

One formulae for…..

August 11, 2017 | Excel 2003 Help, Excel 2010 Help | 4 Comments

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 …

July 27, 2017 | Excel 2003 Help, Excel 2007 Help | 0 Comments

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 …

May 18, 2017 | Excel 2003 Help | 0 Comments

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 …

January 30, 2017 | Excel 2003 Help, Excel 2010 Help | 4 Comments

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 …

September 19, 2014 | Excel 2003 Help, Excel 2010 Help | 0 Comments

Topic Groupings

AND Array chart Colours in Excel Conditional Formatting count countif COUNTIF Function data Date Dates & Times Excel Excel-Vba Excel 2010 Excel Formula Excel Formulas Excel Functions Excel VBA Code filter find formula formulas function functions help IF IF Function index London LOOKUP Macro Macros. match percentage Pivot Table search sort SUM Sum Function SumIf SUMIFS table time VBA vlookup

Pages

  • All Excel Help Posts
  • All Posts
  • Ask a Question
  • Contact
  • Home 8
  • Latest Questions on Excel Geek
  • Post Archive

Categories

  • Excel 2003 Help
  • Excel 2007 Help
  • Excel 2010 Help
  • Excel Formulas
  • Excel Geek
  • Excel VBA
  • Excel VBA Books
  • Favourite
  • Formula
  • Functions
  • Keyboard Shortcut
  • Macros
  • Spreadsheets

Recent Posts

  • Formula to Extract Text from Cell
  • Excel work Lottery prediction
  • Formula Help
  • looking age of last non-matching value
  • solution
© 2014 ExcelGeek. All rights reserved.
Optional footer notes.