In the attached worksheet, I would like to have cell E22 populate the date of the event without using the =TODAY() formula.
The reason I need this is that if we were to email this sheet the next day, it changes the date to that day rather than the date of actual event. This causes problems in the office reporting when we roll up the figures from multiple events.
Is there a fix that maybe we could use a VLookup formula to reference the 2018 Holiday Sales Goals sheet to get the date from that?
In the end, if you type in the location number in cell D23, E22 will show the actual date of the event.
Please let me know if you can help.
Thanks!
Ryan
Get Outlook for iOS
