I am not sure I understand what you are trying to do but the DAY function
returns the day of the month as integer

=DAY(A1)

with May the 5th in A1 it will return 5 then you could just add 1, 2 etc for
the inbetween dates


Regards,

Peo Sjoblom

"force530" wrote:

Upon entering a date range (weekly), i.e., 5-7-05 to 5-13-05 into a form, i
am trying to ref these dates and the dates in bewteen to reflect the date
only in another range of cells. The "EDATE" is ideal, but ref only the month
and not the day.

Using the date ranges above, I would like the function to be ...

7, 8, 9, 10, 11, 12, 13