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

**jammy78** · 01-11-2012, 06:52 AM

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

**Richard Buttrey** · 01-11-2012, 07:07 AM

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

**jammy78** · 01-11-2012, 07:28 AM

Originally Posted by Richard Buttrey

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

Worked a treat!

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

**jammy78** · 01-11-2012, 07:36 AM

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

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

Thread Tools

Display

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

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

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

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

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions