Simple Formula Is Killing Me

[rockyw]

I know this has to be simple. I want to return the date in a cell and if it's blank it returns nothing. The date is moving into thr cell for code so it is blank. Right now I get 1/0/0. Thanks

 

[Joe4]

What is the formula in your cell?

 

[rockyw]

Code puts todays date, 3/3/16

 

[Fishboy]

I know this has to be simple. I want to return the date in a cell and if it's blank it returns nothing. The date is moving into thr cell for code so it is blank. Right now I get 1/0/0. Thanks

Hi Rocky,

To be honest what you just said doesn't really make much sense, or at least we have not got enough information...

If cell (let's say A1) is not blank then another cell (let's say B1) is supposed to be returning a date. If A1 is blank however, B1 should not return a date. Is that generally the idea (give or take the actual cells being the right ones I mean)?

If I have the right idea then the formula in B1 would be something like =IF(A1<>"",TODAY(),"")

Or are you trying to do this with VBA?

 

[Joe4]

ADVERTISEMENT

It it is putting in today's date, how can it be blank?

Can you walk us through exactly what is going on, and post your exact formulas, if you have any?

 

[rockyw]

OK the cell is blank until a code puts in a date. I used =Data!I4 but I get a 1/0/0 when the cell is empty. A code puts a date in and removes it later. I would like to see the date and nothing when the date is gone. Thanks

 

[Joe4]

ADVERTISEMENT

Try this instead:

=IF(Data!I4,Data!I4,"")

 

[Fishboy]

OK the cell is blank until a code puts in a date. I used =Data!I4 but I get a 1/0/0 when the cell is empty. A code puts a date in and removes it later. I would like to see the date and nothing when the date is gone. Thanks

To be honest that still doesn't quite fit how I would expect it to work, however would it not be something like...

=IF(Data!I4<>"",Data!I4,"")

 

[dave3009]

Assuming the cell is blank before the VBA code puts the date in then maybe

=IF(Data!I4, Data!I4, "")

Will return blank if cell Data!I4 is empty, or the value from that cell if not.

 

[rockyw]

Yes that works. It returns the dates and blank where there is none, thanks I looked and looked for an answer. Thanks