Todays date between, < or > than other dates = If / OR Function?

1. Todays date between, < or > than other dates = If / OR Function?

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

2. Re: Todays date between, < or > than other dates = If / OR Function?

=IF(TODAY()>K2,"Free",IF(TODAY()<J2,"Free Today","Booked"))

3. Re: Todays date between, < or > than other dates = If / OR Function?

Originally Posted by Richard Buttrey
=IF(TODAY()>K2,"Free",IF(TODAY()<J2,"Free Today","Booked"))
Worked a treat!

Thanks a lot for this... saved me a lot of time!

4. Re: Todays date between, < or > than other dates = If / OR Function?

Sorry, one more quick question.......

If there's no date in the Booking From (J2) & Booking To (K2) - is there a way to hind the formula result?

It'll be nice to have?

Thanks

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1