If Statement to delete cell or retain contents

[tgclark]

ColA ColB
Date Letter Sent Date file closed

01/01/14
03/01/14
03/01/14
10/01/14
04/01/14

I would like a formula in each row in Col A which would see if there
was a date in ColB; if there was a date then ColA date is deleted; if
there is no date, then ColA is left as it is.

There are many other columns with detail, but the above is the crux of
the issue.

Any help would be appreciated

Excel 2010

Thanks

 

[Ron Rosenfeld]

ColA ColB
Date Letter Sent Date file closed

01/01/14
03/01/14
03/01/14
10/01/14
04/01/14

I would like a formula in each row in Col A which would see if there
was a date in ColB; if there was a date then ColA date is deleted; if
there is no date, then ColA is left as it is.

There are many other columns with detail, but the above is the crux of
the issue.

Any help would be appreciated

Excel 2010

Thanks

You cannot do that with a formula. To actually delete the contents in Col A would require a VBA Macro. Or you could make the cell display nothing by using Condtional Formatting to set the font color to the same as the background color if there is a date in Col B.