I have a need to find what the nearest Friday (without going over--sounds like The Price Is Right, huh) given a submitted date, with certain parameters.<BR><BR>For example...Monday - Sunday dates should show that Friday's date. If the date submitted is 9/29/03, the result should be 10/3/03 (Monday). If the date submitted is 10/3/03, the result should be 10/3/03. If 10/4/03 is submitted, the resulting date should still be 10/3/03. The result doesn't change until the next Monday date.<BR><BR>Thoughts?<BR><BR>= )<BR><BR>C. A.