Forum Discussion
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...
Hello Actug,
Can you please elaborate on what you mean by "Need formula if A2 is later date than A1 then move to Cell A1 on Sheet 2".
Do you mean if the date in Cell A2 of Sheet 1 is later than the date in Cell A1 of Sheet 1 then you wish to select Cell A1 on Sheet 2? Or do you wish to move the date in Cell A2 of Sheet 1 to Cell A1 of Sheet 2?
Actug2
Home
General Discussion
Click here to refresh translation
Excel formula
Actug
Actug OCCASIONAL VISITOR
36m ago
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 help animal rescue as a volunteer
Thanks
Labels:
Formulas and Functions
Add tags
19 Views0 Likes2 Replies
All topics
2 Replies
PReagan
PReagan replied to Actug
22m ago
Hello Actug,
Can you please elaborate on what you mean by "Need formula if A2 is later date than A1 then move to Cell A1 on Sheet 2".
Do you mean if the date in Cell A2 of Sheet 1 is later than the date in Cell A1 of Sheet 1 then you wish to select Cell A1 on Sheet 2? Or do you wish to move the date in Cell A2 of Sheet 1 to Cell A1 of Sheet 2?
Add tags
0 Likes
Actug
Actug replied to Actug
a minute ago
Sorry didn't explain correctly
Sheet 1
Dog's name in A1
I have dog's intake detail in B1
The adoption date in C1.
When dog is adopted I want to move A1 B1 and C1 to sheet 2. Is that possible. What I am trying to do it keep available dogs on sheet 1 and adopted dogs on sheet 2