Thread: Greater than 5 days formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rachael F Rachael F is offline
external usenet poster
  
Posts: 16
Default Greater than 5 days formula
I would like help with a formula for the following:

If A1 is more than 5 working days greater than B1 = 'Failed'
If A1 is equal to or less than 5 working days greater than B1 = 'Passed'

Many thanks.

Rachael
Reply With QuoteReply With Quote