Formula help

[Urlord]

I have the following formula in sheet1 B2
=CONCATENATE(Sheet2!$A2," ",Sheet2!$C2," ",Sheet2!D2,"")

What I would like to do is add "Calibration Due" if the date in sheet2$j2
is 30 days or less from today()

I am using Office 2007

Thanks

 

[bryonwoods30]

should just be an easy if statement

=if(days360(today(),otherdate)<30,=conc formula with calibration due, =conc formula without calib due)

 

[Urlord]

You put me on the right path. Thank you I made some modifications and it works

 

[T. Valko]

You put me on the right path. Thank you I made some modifications and it works

I'm not sure what you mean by:

30 days or less from today()

But, if that formula does what you want it can written like this:

=Sheet2!$A2&" "&Sheet2!$C2&" "&Sheet2!D2&IF(DAYS360(TODAY(),Sheet2!J2)<30," Calibration Due","")

 

[Urlord]

I'm not sure what you mean by:



But, if that formula does what you want it can written like this:

=Sheet2!$A2&" "&Sheet2!$C2&" "&Sheet2!D2&IF(DAYS360(TODAY(),Sheet2!J2)<30," Calibration Due","")

Thanks
What I meant by 30 days from today() was that I wanted "Calibration Due" to show up if todays date was within 30 days of the annual calibration being due.