Hello,
I have a list of full birthday dates in separate rows. Like:
1985.07.05
1988.01.08
...
I'd like to achieve two things. First, I'd like to sort dates so I'd see nearest b-days, like:
1 - 1988.01.08 (its first, because January 8 goes before July 5)
2 - 1985.07.05
...
And second, I'd like to see a year count, thats going to be on next b-day.
Could you please give any references on how to write correct formulas for these goals?
You can extract dates and add Age.
Then add filter in first row and sort by Date column.
"Relax. What is mind? No matter. What is matter? Never mind!"
Thank you zbor! Thats what I was looking for.
It seems sorting doesnt work very well with dates, that are on the same months.
6.23 (June 23) shows as being first compared to 6.6 (June 6).
Try this in B2 then sort:
=A2-DATE(YEAR(A2),0,0)
"Relax. What is mind? No matter. What is matter? Never mind!"
It suggest there is error in formula. As I remember, one cannot directly add or subtract dates. Maybe thats the cause.
Try use ; instead of , as a delimiter
"Relax. What is mind? No matter. What is matter? Never mind!"
Formula =A2-DATE(YEAR(A2);0;0) is accepted, but result is rather strange. If A2 is 1988.01.08, then this returns 1900.02.08
Format it as number.
You will get integers.
From 1 to 366. Number of days after New Year (including NY).
"Relax. What is mind? No matter. What is matter? Never mind!"
Yes, but why did 01.08 (January) changed to 02.08 (February)?
Doesn't matter, but you can use:
=A9-DATE(YEAR(A9);1;0)
To fix it.
"Relax. What is mind? No matter. What is matter? Never mind!"
Doesn't matter, but you can use:
=A9-DATE(YEAR(A9);1;0)
To fix it.
"Relax. What is mind? No matter. What is matter? Never mind!"
OK - now its working finethank you again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks