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?
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?