Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Macro (https://www.askmehelpdesk.com/showthread.php?t=419407)

  • Nov 25, 2009, 12:19 AM
    kyaw kyaw win
    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.
  • Nov 25, 2009, 07:18 PM
    Fr_Chuck

    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
  • Nov 28, 2009, 09:06 AM
    JBeaucaire

    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.

  • All times are GMT -7. The time now is 01:45 AM.