I have had a ton of help here today so thanks to all.
this is my last issue.
three columns
"D" Order Date...date invoice was entered
"E" Measure date...date measure was actually done
"F" Anticipated measure date...Date 14 days after "A"
If "E" when entered is past the date in "F" I need for nothing to happen.
if "E" when entered is within the 14 day period i need "F" to show nothing
In F currently is the following:
=if(d4=0,"",d4+14) date in F stays no matter what
I tried in F the following:
=if(E4>D4,D4+14,D4)
although the above works how do I make the date clear if the date is before that entered in E?
Thanks
Bookmarks