Ryan Lange
Occasional Contributor
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.



Get Outlook for iOS
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies