Hello,
Im going little crazy for the last hour.
I have several workbooks with dates column A.
It's in custom format, dd.mm.yy
I just need a simple '1' in column B next to all the dates that are within the last 2 weeks of December.
Some workbooks have 1000+ dates for over last 20 years.
Can anyone please help me?
It can be VBA or just formulae.
Thank you in advance!
James
Im going little crazy for the last hour.
I have several workbooks with dates column A.
It's in custom format, dd.mm.yy
I just need a simple '1' in column B next to all the dates that are within the last 2 weeks of December.
Some workbooks have 1000+ dates for over last 20 years.
Can anyone please help me?
It can be VBA or just formulae.
Thank you in advance!
James