Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
The last row in Column A contains a date.
I need the value in Column A to be expressed in A8 as "Last walk X days/weeks/months ago" as follows:
If X is less than 7 days then it's "Last walk X days ago"
If X is equal to 7 days then it's "Last walk 1 week ago"
If X is less than 1 month then it's "Last walk X weeks ago" (the number of complete weeks)
If X is equal to 1 month then it's "Last walk 1 month ago"
If X is greater than 1 month and less than 2 months then it's "Last walk X weeks ago"
If X is equal or greater than 2 months then it's "Last walk X months ago" (the number of complete months)
Many thanks!
I need the value in Column A to be expressed in A8 as "Last walk X days/weeks/months ago" as follows:
If X is less than 7 days then it's "Last walk X days ago"
If X is equal to 7 days then it's "Last walk 1 week ago"
If X is less than 1 month then it's "Last walk X weeks ago" (the number of complete weeks)
If X is equal to 1 month then it's "Last walk 1 month ago"
If X is greater than 1 month and less than 2 months then it's "Last walk X weeks ago"
If X is equal or greater than 2 months then it's "Last walk X months ago" (the number of complete months)
Many thanks!