If less than today() insert nothing ("") otherwise insert single space (" ")

[asolopreneur]

I want to insert nothing if date is less than today otherwise a single space. I've tried if(B2>today(),""," ") and if(B2=today()-1,""," ") but not working.

Please check https://docs.google.com/spreadsheet...pUIlzR-oIANyBSHjVbcOv5t-I/edit#gid=2114046438

 

[FormR]

I want to insert nothing if date is less than today otherwise a single space. I've tried if(B2>today(),""," ")

Hi, it looks like you have your equality test the wrong way around.

if(B2<today(),""," ")

 

[Andrew_UK]

You were so close. Just swap the inequality;

<today(),""," ")
<today(),""," ")
=IF(B2<TODAY(),""," ")

<today(),""," ")

I tested this just now. The only problem I can see is that in both instances "" and " " the result is blank when filtered. Which isn't all the helpful.

Also Excel has an annoying habit of not viewing "" as an entirely blank cell. Once you've copy pasted values then the Ctrl/directional keys still jump over these as though there were something there and CountA formulas count them as non empty. If what you are aiming for is a truly empty cell and you don't need it to be dynamic then return "DELETE" and then use find/replace to Find DELETE and replace with nothing - this will leave the cell truly empty.
</today(),"","></today(),"","></today(),"",">

 

[asolopreneur]

Hi, it looks like you have your equality test the wrong way around.

if(B2<today(),""," ")

Not Working on Google sheets Please refer Google sheet https://docs.google.com/spreadsheet...pUIlzR-oIANyBSHjVbcOv5t-I/edit#gid=2114046438

 

[asolopreneur]

Thanks for the information.

 

[FormR]

Not Working on Google sheets

Hi, this is an Excel forum

 

[FormR]

I downloaded your file to Excel and with the exception of C1 which appears to contain text and not a date it appears to work for me. In what way does it not work for you?

Excel 2013/2016
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	17 Dec 2017	Mon18	19 Dec 2017	20 Dec 2017	21 Dec 2017	22 Dec 2017	23 Dec 2017	24 Dec 2017	25 Dec 2017	26 Dec 2017	27 Dec 2017	28 Dec 2017	29 Dec 2017	30 Dec 2017	31 Dec 2017
2
3	TRUE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
4	FALSE	TRUE	FALSE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
If less than today ()

Cell Formulas
Range	Formula
B2	=IF(B1),""," ")
B3	=B2=""
B4	=B2=" "