Help with IF statement and dates

[BAM]

I need some help on writing an if statement that would do the following

IF today's date is equal to or between a specific start date and specific
finish date (referenced in other cells), enter "underway" in the cell. IF
today's date is before the start date, enter "planning." If today's date is
after the finish date enter "completed."

Thanks in advance for any help,

BAM

 

[Roger Govier]

Hi
With Start date in A1 and End date in B1
=IF(TODAY()<A1,"Planning",IF(TODAY()>B1,"Completed","Underway"))

 

[FloMM2]

Bam,
Try this:
Cell A1 is "Today's Date" without ""
Cell B1 is "Start Date" without ""
Cell C1 is "Finish Date" without ""
Format Cells A1, B1, C1 as mm/dd/yy

In Cell A2 type "=NOW()" without ""
In Cell B2 type start date
In Cell C2 type finish date

In Cell B3 type "=IF((A2=B2)*OR(B2<A2<C2),"underway","planning")" without
the first " or last "

hth