Previous Topic Next Topic

Calculating anniversary dates

Closed
cbbier - Oct 24, 2008 at 09:06 PM
onetera Posts 7 Registration date Tuesday October 21, 2008 Status Member Last seen May 16, 2009 - Oct 25, 2008 at 07:02 AM
Hello,

I have a worksheet with several start dates in date format...mm/dd/yy. I want to find the upcoming key anniversary dates (5 years, 10 years, 15 years, 20 years, 25 years, 30 years, 35 years, 40 years, 45 years) of all employees so recognition can be given. I want the actual date to show (mm/dd/yy) so I don't miss recognizing them. I have been able to add the formula for number of years, months and days in one cell. I just need the mm/dd/yy of those key anniversary dates. I will not need the data of those without a key anniversary date.

Thank you.

1 response

Answer 1 / 1
onetera Posts 7 Registration date Tuesday October 21, 2008 Status Member Last seen May 16, 2009 2
Oct 25, 2008 at 07:02 AM
hey there,

here is a link which might help you :

http://office.microsoft.com/en-us/access/HA010550721033.aspx?pid=CH011188381033

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

Hello, Why the end to end encryption message will appear several times in a chat at different dates with no other conversation? Does that mean the chat has been deleted and activated again, then deleted again at another date and reactivated again?

1 response
IF statements with dates and criteria
jimbabama -
Mazzaropi -

Hello,
I needs assistance with "If "statements and criteria within the statement .

Column A has a set of start dates
Column B has a set of End dates
Column C has the If statements with criteria resulting in a date.

So here is what I'm trying to create:
IF A= B then the result in C is the B date, but if A is not = B, then result in C is B date +14 more days.

I have read many examples and can seem to be able to put all of this into one If statement.

Any help is greatly appreciated.

Thank you.

3 responses
blank white page for website
yadaves -
ac3mark -

there is white blank page after loading [REMOVED BY MODERATOR]

help me to get it solve so that i am able to get my result ...

1 response
using web browser page loads but screen blank
inchoate -
leo -

Hello,
On my laptop, none of my web browsers are able to actually display any page on the internet. I will say the page is loaded, but the web browser window will be totally blank. One that particular computer, I tried firefox, googlechrome, and internet explorer. For explorer it showed a message saying it couldn't find any of the pages I tried to open, I think it said that there was an HTML error. What should I do?

Laptop Configuration:
Dell insperon notebook w/
Windows XP

Web browsers:
Google Chrome
Modzilla Firefox
Internet explorer

16 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

Hello,
hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one...

regards
hardy

6 responses