Date formula required - simple?

[mikemcbain]

G'day Magicians

I have a column with around 100,000 dates in it mostly from the last one year period.

I would like a formula to put into the next column that returns an "O" if the day was an odd number or an "E" if the day was an even number . for example 04/04/2019 O and 05/04/2019 E

With thanks

Mike.

 

[Dave Patton]

Excel 2010
	A	B	C
2	04-04-19	FALSE	O
3	05-04-19	TRUE	E
4
1b

Cell Formulas
Range	Formula
B2	=ISEVEN(A2)
B3	=ISEVEN(A3)
C2	=IF(ISEVEN(A2),"E","O")
C3	=IF(ISEVEN(A3),"E","O")

 

[mikemcbain]

Dave, many thanks for your quick response and perfect solution.

Greatly appreciated

Best regards

Mike.
Tasmania.

 

[Dave Patton]

Thanks for the feedback. Dave