## IF Formula if Time is Greater than 10am

Hi, Here is my issue. In column “F3” I have a import time in the format 09:00. In column “T3” I’m trying to create a formula …

## Nested IF Statements Matching Age to School Year.

I am trying to create a spreadsheet which matches a Child’s date of birth to their school year. For example: Date of birth Year group 1 September 2008 to …

## Calculating the Next Due Date from Two Different Dates

Hi Everyone, I am currently working on a spreadsheet for someone at work and require a little help as to how best format and organise the cells to minimise the …

## filtering cells based on duplicity and date

I currently have a long table of data, in which i need to highlight the duplicates by colour but only in the last four weeks(rolling). I dont mind …

## dates automatic copy to other sheet

I have created individual annual leave worksheets with a pop out calendar for all employees, so now when I am inputing dates in to individual worksheets I …

## IF-AND Compare Month and Year

I’m working on a sheet that has a calculated date (i.e., condition met,  date +/- days = result). I don’t need the day field, but do need to …

## Calculate Difference Between Dates if Condition Met Excel Formula

Hi – hope you can help. I have a spreadsheet with the following columns a) Qualified b) Finished c) Length of Partnership (there are other columns but …

## How to Separate Date & Time in Excel

Hello, in A1 I have a date and time shown as 201008061730 (yyyymmddhhmm). How do I get the date element into B1 as 06/08/2010 and in C1 the time as 17:30? …

## Calculate Difference in Dates using DATEDIF Function

The DATEDIF function in Excel will calculate the difference between two dates, showing you the answer in days, months, or years depending on how you specify it …

## calculating dates between UK dates

Hi no matter how I format the dates in Excel when i perform various date calculations to work out the number of days between dates it counts them as US

## How to Use Excel’s WEEKNUM Function

Microsoft Excel’s WEEKNUM Function returns a number that indicates where that particular week falls numerically within a year. The format for this …

## Using Excel’s MONTH Function

Excel has a built in function that will calculate the month of a specified date and return the integer value for that month. For example 14 Jan 10 will return …

## Calculate Working Days Excluding Holidays Between two Dates

Sometimes it is useful to calculate the amount of days between two dates. But an even more useful tool is to be able to calculate the number of working days …

## Calculate Working Days Between two Dates

Excel has an inbuilt function that allows you to work out the number of working days between two dates. In fact, it is just as simple as working out the total …

## Insert Current Date and Time in a Cell

Have you ever needed to show the current date and time combined into one cell?  Simple solution is to click into the cell you want it displayed and type …

## Always Show the Current Date in an Excel Cell

Sometimes it is required to always have the current date displayed on a workskeet whenever you open it.  A very quick and easy method is to type =TODAY() in a …

## How to Seperate Date and Time in Excel

Sometimes when you receive data in an Excel file that has been downloaded from a database the date and time are in the same column together (as shown in column …