DateDiff

I have a spreadsheet that has value in it like this

6/23/2008 11:54

I want to verify if it's 3 month or more then the current date from now

I can't seem to find the proper VBA code for it ..

any help ?

Thanks

It's telling me Under and that doesn't seem to work.

Since it's OVER 3 month from now .. !

Maybe i don't understand it correctly ,

If it's over 3 month shouldn't it say "Over" ?

Like it's been more then 3 month right ?

Ok so what i want is to now it's it's been more then 3 month since the date value that i gave ..

6/23/2008 11:54

Like since June 2008 to Today , it's been more then 3 month , that's what i need.

Thanks guys !

You can use DATEDIF like this

=IF(DATEDIF(A1,TODAY()+1,"m")>=3,"Over","Under")

Originally Posted by davesexcel

Try This

=IF(A1<DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY())),"over","Under")

That works ..


Now if i have a full columns of this and i want to verify every cells of this column and add on the next cell "Over" Or "Under"

how would that be in VBA scripting ?

thanks