Ask Experts Questions for FREE Help !
Ask
    kyaw kyaw win's Avatar
    kyaw kyaw win Posts: 1, Reputation: 1
    New Member
     
    #1

    Nov 25, 2009, 12:19 AM
    Macro
    Dear Sir
    May I know, How to write macro code for two date difference for 100 rows. And If difference result more than 60, I will write "Lost Follow up" text in excel column.
    Fr_Chuck's Avatar
    Fr_Chuck Posts: 81,301, Reputation: 7692
    Expert
     
    #2

    Nov 25, 2009, 07:18 PM

    Moved, you "asked" your question as a answer to someone else's question.
    Please be careful. If you need to add more info, merely answer your own question to add more details
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #3

    Nov 28, 2009, 09:06 AM

    If the two dates are in column A and column B...

    A1 - earliest date
    B1 - later date

    This formula in row1 in an empty column:

    =IF(B1-A1>60, "Lost Followup", "OK")

    Copy that cell down the column you put it in for 100 rows.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel Macro [ 13 Answers ]

I have some code that loops through a row and a column and compares data. When it finds the values being equal it copies the columns the row is in and pastes it on another sheet along with the previous value of the column. For Each CCell In Range("C2:C65418") If Not IsEmpty(CCell.Value)...

Macro help [ 3 Answers ]

Hi all, I am currently working with a dataset where the data in column A is empty until a user enters a rank (i.e. like ranking grades in ascending order). Currently the macro takes the number and moves the row entry to the top by assuming that the rank is to be the highest rank (it then takes...

If statement macro [ 10 Answers ]

Hello , I have an excel macro to take data from one spreadsheet and format in a partciular method. Now I want to add an if statement like I have an excel formula that works but I need it put into the macro. The formula is: if(AA21="USD", "6YB", "6YA") Help Thanks

Cut and paste a macro? [ 3 Answers ]

I'm trying to create a spreadsheet based on an older version that has a macro. When open both workbooks, cut and paste the old to the new, open vb editor and drag the forms folder and modules folder to the new workbook the macro runs but is broken (it works in the old workbook) Is there more to...


View more questions Search