Drofidnas
Board Regular
- Joined
- Jun 30, 2004
- Messages
- 126
Hi
By using
I can perform a check of the two cells and even though one is formatted as Oct-14 an the other is 23/10/14
I will get a 1 - ie, they are in the same month.
How can I do this programmatically with VBA?
I have
but I need some formatting around those statements.
Thanks for any help
Chris
By using
Code:
=IF(TEXT($I18,"mmyy")=TEXT(L$2,"mmyy"),1,0)
I can perform a check of the two cells and even though one is formatted as Oct-14 an the other is 23/10/14
I will get a 1 - ie, they are in the same month.
How can I do this programmatically with VBA?
I have
Code:
If Cells(18,9) = Cells (2,12) then
Cells (4,2) = 1
End If
but I need some formatting around those statements.
Thanks for any help
Chris
Last edited: