Formula for Filling Columns based on dates

[Kurt Radecki]

Hello-

What would the formula be to add an text to a cell based on the dates in
other cells? I'm tyring to add an X to a cell if a date is between a
three month range. More specifically, I'm trying to show that a task
will take place in one of four quarters in a year based on a date in a
column that I plan to hide.

So far, this is what I have:
=IF(AND((G6>=DATE(2004,12,1)),(G6<=DATE(2004,2,28))),"X","")
where G6 is the date. It doesn't seem to work.

Thanks!
-Kurt

 

[Biff]

Hi Kurt,

Try this:

=IF(G6>=DATE(2004,2,28),IF(G6<=DATE(2004,12,1),"X",""),"")

Biff

 

[Rick]

I'm not sure if this helps but I got it to work by putting
an actual date in H9 & H10 and doing this, your excell
must not reconige your date because this worked perfectly
for me. if that will work for you, you can always put the
quarter start and end date in a hidden column. and if you
use absolute references you can replicate or copy paste
your formula.


=IF(AND((G9>H9),(G9<H10)),"X","")

 

[Kurt Radecki]

Thanks Rick. That definitely helped. -Kurt

I'm not sure if this helps but I got it to work by putting
an actual date in H9 & H10 and doing this, your excell
must not reconige your date because this worked perfectly
for me. if that will work for you, you can always put the
quarter start and end date in a hidden column. and if you
use absolute references you can replicate or copy paste
your formula.


=IF(AND((G9>H9),(G9<H10)),"X","")




on the dates in


is between a


that a task


on a date in a