IF Statement Possible or?

[YNWA123]

Hi. Trying to find a solution for a Google Sheet or Excel file. Feel like I need an IF statement, then maybe a Today() formula or something to handle days. I need the following

Enter a value in cell A1 (headline for a google ad) and a date/time range in B1, this could be B1 as start date and C1 as end date and then have a cell (say D1) pull a blank or the headline depending on if the date condition is fulfilled?

e.g.
so the 'if' cell (A1) stays blank unless that it's a date from the time frame (B1 to C1), in which case it would show value 'x'?

Do that make sense?

 

[cmowla]

Where you you only carry down the formulas in Columns D and E. (You do NOT carry down the formula in Column F!)

And here is when it would not display the advertisement:

 

[YNWA123]

View attachment 47558


View attachment 47560

Where you you only carry down the formulas in Columns D and E. (You do NOT carry down the formula in Column F!)

And here is when it would not display the advertisement:
View attachment 47561

Thanks you I will check this out.

 

[YNWA123]

Quick

View attachment 47558


View attachment 47560

Where you you only carry down the formulas in Columns D and E. (You do NOT carry down the formula in Column F!)

And here is when it would not display the advertisement:
View attachment 47561

Quick one, is column C needed? If I want to enter start and end date/times manually is that ok?

 

[cmowla]

Only to calculate the end date time if you don't want to. So no.

 

[YNWA123]

Only to calculate the end date time if you don't want to. So no.

cool. Thanks.