harrinho
New member
- Joined
- Mar 22, 2019
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 16.22
Hi everyone,
As simple as it might seem I struggle with the mapping of the days at the format they come through Salesforce export. So, in the attached I have a list of dates for Salesforce opportunities in the sfdc tab, and I want to assign a number of day next to these dates (i.e. 16/3/2019 to be Day 1, 17/3/2019 to be Day 2 etc.)
What I want is to apply a format in the date in Sheet 1 that when I paste the list of date as pulled from Salesforce in SFDC tab, to map the Day Join column and don't have errors.
Any ideas what this format should be please?
View attachment date mapping.xlsx
As simple as it might seem I struggle with the mapping of the days at the format they come through Salesforce export. So, in the attached I have a list of dates for Salesforce opportunities in the sfdc tab, and I want to assign a number of day next to these dates (i.e. 16/3/2019 to be Day 1, 17/3/2019 to be Day 2 etc.)
What I want is to apply a format in the date in Sheet 1 that when I paste the list of date as pulled from Salesforce in SFDC tab, to map the Day Join column and don't have errors.
Any ideas what this format should be please?
View attachment date mapping.xlsx