Excel Tips 1

Excel Tips:

(1) To determine the quarter of a particular date, use formula:

=ROUNDUP(MONTH(A1)/3,0)

(2) To determine the last day of a month, use formula:

=DATE(YEAR(A1),MONTH(A1)+1,0)

(3) To determine no. of days between 2 dates, use hidden Excel formula:

=DATEDIF(startdate, enddate,""d"")

(4) Instead of using formula: =IF(OR(A1=1,A1=3,A1=5), TRUE, FALSE)

, use formula =IF(OR(A1={1,3,5}), TRUE, FALSE)

Replace wording in RED with your specific cell.