I am trying to set up a formula to check milestones which fall between
15 days + or - of todays date using IF. If the result matches I want
the true value to be text in another cell.
I've come up with the formula to check if it matches today (see below)
but am having problems when trying to add in the +/- 15 days.
=IF(C17=B26,B17,0)
C17 is milestone date
B26 is todays date
B17 is milestone description
I also want to extend this to multiple cells.
Any help would be appreciated.
--
rediproof
------------------------------------------------------------------------
rediproof's Profile:
http://www.excelforum.com/member.php...o&userid=23714
View this thread:
http://www.excelforum.com/showthread...hreadid=374135