Hi all,
I'm having difficulty with a nested function..... in fact I'm stuck!
I have created a booking form & I have two dates in the form:
Booking From (cell J2)
Booking To (K2).
Now I have a column called Status (O2) & I want it to be able to show the following:
If:
Today > Booking To = "FREE"
or
Today < Booking From = 'FREE TODAY (Future Booking)
or
Today between Booking To and Booking From = "BOOKED"
Can anyone help with the formula..... it's giving me a headache!
Many thanks
Bookmarks