Forum Discussion
Actug
Nov 02, 2019Copper Contributor
Excel formula
Sheet 1 Cell A1 has date dec 1 2019 Cell A2 has a date Jan 1 2020 Need formula if A2 is later date than A1 then move to Cell A1 on Sheet 2 I am retried and forgot how to do this I am trying to hel...
Actug
Nov 02, 2019Copper Contributor
I will look at it after mass in the morning. Thank you so much. The non for profit is in the south and I am in Indiana. The software she was using was file maker pro and ex employee took software and neither of us know how to use it. She had customized it for the rescue. I only know Excel and making links. Nothing about macros. So thank you and I will communicate tomorrow. Good night
Actug
Nov 03, 2019Copper Contributor
- PReaganNov 03, 2019Bronze Contributor
Can you please describe the message that you are seeing? I reviewed the screenshot that you shared but do not see a message.
Additionally, is it ever possible that the intake date is later than the adopted date? If not, then the original file that I shared is designed to move all dogs that have been adopted (i.e. the adoption date is later than the intake date) from sheet 1 to sheet 2.