Formula/VBA to identify order of entry dates

lesmielles · #1 02-08-2017, 03:06 AM

Hi, I am comparing some questionnaire responses (baseline, 3 month follow-up, 6 month follow-up). I have a full list of all entries with dates when the questionnaire was administered, but I need to identify which entries were baseline (1), 3 month follow-up (2) or 6 month follow-up (3), so that I can calculate average before and after scores. Essentially, I want to produce the 'Date sequence' column which I have highlighted. I assigned '1', '2', '3' manually, but as there are hundreds of unique IDs, I want a formula to complete the rest.

Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula working wrong, I can't identify why.	rajeshn_in	Excel	1	01-09-2017 03:59 AM
How to identify Overlap Dates data	golden618	Excel Programming	0	10-28-2015 04:34 AM
Assistance with VBA Code to identify and highlight dates in a word doc	shaunlthomas	Word VBA	1	08-13-2015 05:25 PM
IF formula using dates	rindelsk	Excel	1	04-06-2015 01:15 AM
Date/Time Formula for Entry level XL user	talon1driver	Excel	2	09-18-2014 02:32 PM