D Dominic Oct 29, 2008 #1 I am trying to set up a function that will prompt me 3 weeks from a specific date in a cell.
G Gary''s Student Oct 29, 2008 #2 =IF(DATEVALUE("12/25/2008")-TODAY()<21,"less than three weeks to Christmas","")