Excel Date Grabbing First 2 Numbers

  • Thread starter Thread starter Arr Livingston
  • Start date Start date
A

Arr Livingston

I need to have 4 IF statements in one cell that do a conditional chec
on a date cell. I need to get 4 different totals from other cell
depending on what the first 2 characters are in this date cell.

Ar
 
Hi

It depends on exactly which 2 characters you want and how the cell is
formatted.
If the cell is a date and you want the month, use =MONTH(A1), if you want
the date use =DAY(A1)
Without a bit more information it is difficult to advise you on your 4 IFs.

Andy.
 
Back
Top