Thread: If function calculating date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
extrudebg extrudebg is offline
external usenet poster
  
Posts: 1
Default If function calculating date

Return Date $ Recovered
8/14/06


I need some help with a IF calculation. Basically I need a formula
that will calculate this sentence. " If A2 is more than 5 days old
then populate B2 as 0. If A2 is less than 5 days old leave B2 blank."

Any help would be greatly appreciated.

Dennis


--
extrudebg
------------------------------------------------------------------------
extrudebg's Profile: http://www.excelforum.com/member.php...o&userid=37892
View this thread: http://www.excelforum.com/showthread...hreadid=574297

Reply With QuoteReply With Quote