When a column has a date another equals 1

**Mikiel** · 10-26-2011, 07:56 AM

Hi All,

New to this.

The problem I am having probably has a really simple solution.

I have a column which I enter dates into. I need the column next to it to equal 1 when the date has been entered. Many Google searches have resulted in me being even more confused.

Help help help.

Thanks

Mike

**Azam Ali** · 10-27-2011, 03:29 AM

let your date is in A1, then in B1 use

=IF(LEN(A1)=5,1,"") and copy down

**Mikiel** · 10-31-2011, 05:00 AM

Hi,

Thanks for the reply. I give this a go but it just enterered 01/01/1900

Originally Posted by Azam Ali

let your date is in A1, then in B1 use

=IF(LEN(A1)=5,1,"") and copy down

**Fotis1991** · 10-31-2011, 05:14 AM

Hi!

Change the format in B1, to General.

**Mikiel** · 10-31-2011, 05:18 AM

Amazing!!!!! Thank you!!

**Azam Ali** · 10-31-2011, 05:21 AM

If your problem is solved, mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.