Formula help again pse

dougie · Mar 29th, 2004, 04:03 PM

To many IF's, AND's & OR's for me to tackle.

I have the following formula which changes the status if five days have elapsed since the date of authorising to the date received.

Date authorised is column B, Date received is column C, Status column D

=if((today()-b2>5)*(c2="")=1,"chase","ok")

Date authorised date received status.

I now have another column A, WHICH IS DATE ACCEPTED. What i would like to do is add to the above formula by saying if date authorised is blank and todays date is five days after the date in column A, then type a message saying " chase authorising officer" if less than five days say OK.

Can this be done, thanks in anticipation

Zack Barresse · Mar 29th, 2004, 04:08 PM

something like...

=if(b2="","",if(today()-a2>5,"Chasing authorising officer","OK"))

Mar 29th, 2004, 04:03 PM	#1
dougie Join Date: Mar 2004 Posts: 45	Formula help again pse To many IF's, AND's & OR's for me to tackle. I have the following formula which changes the status if five days have elapsed since the date of authorising to the date received. Date authorised is column B, Date received is column C, Status column D =if((today()-b2>5)*(c2="")=1,"chase","ok") Date authorised date received status. I now have another column A, WHICH IS DATE ACCEPTED. What i would like to do is add to the above formula by saying if date authorised is blank and todays date is five days after the date in column A, then type a message saying " chase authorising officer" if less than five days say OK. Can this be done, thanks in anticipation

Mar 29th, 2004, 04:08 PM	#2
Zack Barresse MrExcel MVP Join Date: Dec 2003 Location: Oregon, USA Posts: 9,624	something like... =if(b2="","",if(today()-a2>5,"Chasing authorising officer","OK")) __________________ Regards, Zack Barresse All Excel Functions (If you would like comments in any code, please say so.)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode