If date is in future return no value, otherwise return in a new cell the month i.e june=6

**incommlyndon** · 10-10-2013, 06:05 AM

Hello,

I am really stuck and would like to see if anyone can help me. I am creating a sheet which tracks new bookings that come into our company and then tracks performance on how long it takes us to get things sent out.

I have a seperate tab which pulls all the info together and tracks performance. So I am counting how many bookings come in per month. But if the date of the meeting hasnt taken place yet I dont want to include it in the perfomance (as it will say that we havent done what we need to do yet and put down 0%)

**incommlyndon** · 10-10-2013, 06:07 AM

I did try =if(A3=">DATE","",MONTH(A3) but it doesnt seem to do it

**Fotis1991** · 10-10-2013, 06:07 AM

Hi

Try using something like this.

=IF(Cell that includes a date>today(),"",your other formula)

**incommlyndon** · 10-10-2013, 06:22 AM

Thank you Fotis,

that seems to have worked. One other thing, now if the cell its looking at is blank it returns a 1 in the cell. So I need to do something like:

=IF(M2>TODAY(),"",=IF(M2,"","",MONTH(M2))

but I have done something wrong there?

**Fotis1991** · 10-10-2013, 06:44 AM

You could try.

Formula:

Please Login or Register  to view this content.

**incommlyndon** · 10-10-2013, 07:46 AM

Thank you Fotis,

I have a new query...

I am trying to now add all the meetings that happened in a certain month from this column.

So I have tried =SUMIF('Booking Information'!N3:N600,MONTH(8)) it returns 0 as opposed to what it should be of 4

**Fotis1991** · 10-10-2013, 07:53 AM

Do you mean?

=COUNTIF('Booking Information'!N3:N600,8)

**incommlyndon** · 10-10-2013, 07:55 AM

its comes back with TRUE and doesnt return the sum of the count?

**Fotis1991** · 10-10-2013, 07:57 AM

In range N3:N600 you have numbers. Don't you?

**incommlyndon** · 10-10-2013, 07:59 AM

in the N column i have the formula =IF(OR(M2>TODAY(),M2=""),"",MONTH(M2)) which returns a number based on the month so if august it returns 8

**Fotis1991** · 10-10-2013, 08:03 AM

My suggested formula works great under this condition. If you have problem to handle this, then:

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**incommlyndon** · 10-10-2013, 09:48 AM

Hi Fotis,

I have now attached the file and want the N column formula we were speaking about to go into the Performance tab in B11 for august, c11 for september etc...

**Fotis1991** · 10-10-2013, 10:02 AM

This makes no sense for me. An empty worksheet(with out data at all) and now there is not column N but something else.. There are not numbers of months but text...

Sorry but i am not able to following you.

If date is in future return no value, otherwise return in a new cell the month i.e june=6

LinkBack

Thread Tools

Rate This Thread

Display

If date is in future return no value, otherwise return in a new cell the month i.e june=6

Re: If date is in future return no value, otherwise return in a new cell the month i.e jun

Re: If date is in future return no value, otherwise return in a new cell the month i.e jun

Re: If date is in future return no value, otherwise return in a new cell the month i.e jun

Re: If date is in future return no value, otherwise return in a new cell the month i.e jun

Re: If date is in future return no value, otherwise return in a new cell the month i.e jun

Re: If date is in future return no value, otherwise return in a new cell the month i.e jun

Re: If date is in future return no value, otherwise return in a new cell the month i.e jun

Re: If date is in future return no value, otherwise return in a new cell the month i.e jun

Re: If date is in future return no value, otherwise return in a new cell the month i.e jun

Re: If date is in future return no value, otherwise return in a new cell the month i.e jun

Re: If date is in future return no value, otherwise return in a new cell the month i.e jun

Re: If date is in future return no value, otherwise return in a new cell the month i.e jun

Thread Information

Users Browsing this Thread

Similar Threads

Return a date of a day of the week in the future

[SOLVED] Compare strings for match in separate worksheet and return nearest future date

A formula to look at cell containing a date and return number of days in that month.

Datedif but for date in future and to return formatted time value

If column A is a June date, return the dollar value for that line item.

Bookmarks

Bookmarks

Posting Permissions