CoffeeGuru
Registered User.
- Local time
- Today, 14:14
- Joined
- Jun 20, 2013
- Messages
- 121
I have a spreadsheet that I am importing weekly.
it only contains a year and week number
I could add the week end date in excel using a formula like
=DATE(A2,1,1)+((A1-1)*7)-WEEKDAY(DATE(A2,1,1)+(A1-1)*7,2)+6
which basically takes the two fields and converts it to an excel date in another field, which can be formatted as a real date.
OR
can Access do this on import and if so how do I go about doing it?
it only contains a year and week number
I could add the week end date in excel using a formula like
=DATE(A2,1,1)+((A1-1)*7)-WEEKDAY(DATE(A2,1,1)+(A1-1)*7,2)+6
which basically takes the two fields and converts it to an excel date in another field, which can be formatted as a real date.
OR
can Access do this on import and if so how do I go about doing it?
