Can someone tell me whats wrong with this

amy

=IF(DAY(NOW()) or IF(DAY(NOW()+1))= DAY('Reboot Requests'!C24),'Reboot Requests'!B24,"")The problem seems to be here:

=IF(DAY(NOW()) or IF(DAY(NOW()+1))= gives me an error.....

What is the expected outcome (answer) you would like to see?

plettieri


Originally Posted by Xeneize12=IF(DAY(NOW()) or IF(DAY(NOW()+1))= DAY('Reboot Requests'!C24),'Reboot Requests'!B24,"")The problem seems to be here:

=IF(DAY(NOW()) or IF(DAY(NOW()+1))= gives me an error.....

The OR() worksheet function returns TRUE or FALSE depending on the values that are passed to it, for example

=OR(1=1,1=2)

would return TRUE because the first statement is TRUE, even though the second one isn't...

In your case, you need to evaluate both conditions:

=IF(OR(DAY(NOW())=DAY('Reboot Requests'!C24),DAY(NOW()+1))=DAY('Reboot Requests'!C24)),'Reboot Requests'!B24,"")

The result will be a sever name if the day is today or tomorrow, It works with either one but i can get it to work with both.

I need to tell it to print name in that page if the reboot (in this case) will happen today or tomorrow.