PDA

View Full Version : Macro


kyaw kyaw win
Nov 25, 2009, 12:19 AM
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
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
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.