Thread
:
Days to next anniversary
View Single Post
#
12
July 8th, 2007, 09:50 PM posted to microsoft.public.excel.misc
T. Valko
external usenet poster
Posts: 15,759
Days to next anniversary
Ah, but *I* will! argh!
BG
--
Biff
Microsoft Excel MVP
"Sandy Mann" wrote in message
...
It's alright Biff, it's Sunday - no one will notice g
--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"T. Valko" wrote in message
...
"Sandy Mann" wrote in message
...
"T. Valko" wrote in message
...
A2 = hire date
=IF(OR(A2="",A2TODAY()),"",ABS(DATE(YEAR(TODAY()) +(MONTH(TODAY())MONTH(A2)),MONTH(A2),DAY(A2))-TODAY()))
Returns 358 for date in A2 of June 30 2007 and 7 to 1 for July 1 2007
to July 7 2007 respectively.
Ooops! Back to the drawing board!
Why return an empty string for dates in the future?
I'm thinking that the hire date can't be today. You don't have an
anniversary date until you actually have a start date.
--
Biff
Microsoft Excel MVP
T. Valko
View Public Profile
View message headers
Find all posts by T. Valko
Find all threads started by T. Valko