Jimazing Hacks

Use the DATEDIF when you want to caclulate the time between two dates. The time could be how many days, months or years.

The syntax for DATEDIF is
=DATEDIF(Date1, Date2, Interval)
Where:
Date1 is the earlier date,
Date2 is the later date,
Interval is the interval type to return (see table below)

Interval

Meaning

Description

m

Months

Complete calendar months between the […]

 If I have a list of items and I want to find out which of them are duplicates, I can use the following formula in another column.  Say the values are in column A… in column B, row 1, I would use this formula:
 =IF(COUNTIF(A:A,A1)>1,”duplicate”, “unique”)

The COUNTIF counts every match of the value in cell A1 […]