Date Compare Formula

Reply #7

KnuckleHead — Sat, 13 Jun 2009 13:45:46 GMT

Morning all,

For anyone who has to much on their minds (or is a BONEHEAD like me) and generally don't pay attention to dates, below is the formula I was trying to create. But, for those of you that are computer literate (which I'm not), please, don't laugh to loud or long...

If anyone can use it as is or needs to modify it for their purposes, go to it... I posted the complete file for anyone's need or use.

________________________________________________

Draw Date Formula

Ho... [ More ]

Reply #6

CARBOB — Fri, 12 Jun 2009 21:17:52 GMT

It wasn't a waste of time, neither was it a dumb mistake. Sometimes, you can't see clearly. It happens to me, too.

Reply #5

KnuckleHead — Fri, 12 Jun 2009 20:56:03 GMT

CARBOB,

Call me BONEHEAD .

I've been working on several diffuclt (for me) scripts (VBA in Excel) for several days now. I've have had so much on my mind trying to get my automation working correctly, that I placed the : in the wrong place. I didn't realise it until I saw your example. I worked on that formula for 3 hours and didn't realize what I was doing wrong... Placed your example in the cell and made the modifications from Excel to Lotus and it worked.

Sorry to waste your time on du... [ More ]

Reply #4

CARBOB — Fri, 12 Jun 2009 20:32:04 GMT

Yes, the formula I posted works. Show an example.

06/12/09 06/12/09 YES

06/11/09 06/10/09 NO

Reply #3

KnuckleHead — Fri, 12 Jun 2009 20:20:28 GMT

Hello CARBOB and Texas Madman,

Sorry about that, I use Lotus123 ( @ symbol) instead of Excel ( = symbol). Most formulas and VBA work in both speadsheets. In Lotus123 the : is needed for a proper formula format.

Yes CARBOB that's what I'm looking for, but I haven't been able to figure out how to get the 2 date cells to compare for the formula to work properly. In my examples, imagine that the @ is = .

Do you need more info as to what I'm trying to do

Reply #2

Texas MadMan — Fri, 12 Jun 2009 20:03:38 GMT

Also, if this is for microsoft excel you don't need the : in your cell definitions..... : is used when specificing ranges ie. A1:C10

B:7 (incorrect)

B7 (correct

Reply #1

CARBOB — Fri, 12 Jun 2009 19:55:07 GMT

are you looking for something like this? =IF(A49=A50, YES , NO )

What is the @ symbol

Date Compare Formula

KnuckleHead — Fri, 12 Jun 2009 19:09:14 GMT

Good afternoon,

I'm trying to write a date compare formula. Here's my setup:

Cell B:3 = Today's Date 6/12/2009

Cell B:7 = Next Draw Date 6/12/2009

This is what I've tried:

@IF(B:3=B:7, YES , NO )

@IF(@DATEVALUE(B:3)=@DATEVALUE(B:7), YES , NO )

@IF(@TODAY=B:3#AND#@TODAY=B:7, YES , NO )

All of these are giving me ERR .

Once I get the basic formula to work, then I can build on to it. Has anyone done this before