IF statement help

[Wanqus]

Hi

For example.

I have a medication start end and admission date.

and i want to assign a number value of 1 to all the records that the medication start date is 2 days after the admission date.

How do I do this using the ifs function.

Thanks.

[judgeh59]

A2 = Start Date
B2 = Admission Date

Please Login or Register  to view this content.

[Wanqus]

Thank you everything works!

[judgeh59]

great....glad I could help...

If this has been completed to your satisfaction, please set the thread to Solved...If you feel I deserve an increase in my reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...