Extra days depending on seniority and age

Hallo Michael,

probiere es so:

=0+(UND(time of service>=10;age>=45))+(UND(time of service>=15;age>=50))

Claus

P.S.: Du bist hier im deutschsprachigen Excel-Forum. Wenn du unbedingt in Englisch schreiben willst, scrolle auf der Seite ganz nach unten und stelle dort die Sprache um.

Claus

Did you try using the F12 key? (You may need to also press a Fn shift key, depending on how your manufacturer set up your computer.)

Hi, I'm Elise, an independent advisor and I'd be happy to help with your issue.

To use DATEDIF use the format:

DATEDIF( start_date, end_date, interval )

Replace 'start_date' and 'end_date' then for 'interval' use one of the following:

Y The number of complete years.

M The number of complete months.

D The number of days.

MD The difference between the days (months and years are ignored).

YM The difference between the months (days and years are ignored).

YD The difference between the days (years and dates are ignored).

Kind Regards,

Elise

Hi Daisy4me,

I'm Nik, an independent advisor here to guide you on this.

There is a possibility that some numbers have changed in recent days. However, you can find the update global support contact list here:

Microsoft's local hotlines here: https://support.microsoft.com/help/28808

Please check customer support operating hours in your region before you make them a call.

Or via live chat(preferred and quick response):

1. Go here https://support.microsoft.com/en-us/contactus/ and click on "Contact support" or "Open Get the help app" button

2. Type Talk to an Agent (If you have been asked some suggested question, then skip them by saying "No")

4. Click on "Talk to a person."

3. Select Office & Microsoft 365 (for Home) > Next

4. Choose Billing > Next

Please note that opening hours of support channels may depend on your location, and you may experience a little extra wait time due to the COVID-19 situation.

Regards

Nik

Hallo Peter Ess,



Hiermit ausführliche Information über
das Verwalten inaktiver Postfächer in Exchange Online.



"If a hold isn't placed on a mailbox before it's deleted, the contents of the mailbox won't be preserved or discoverable. The deleted mailbox can be recovered within 30 days of deletion, but the mailbox and its contents will be permanently deleted after
30 days if it isn't recovered. "



"Meine Frage bezieht sich darauf, was genau an diesem Punkt passiert."



Welchen Zeitpunkt meinst Du?



"Making a mailbox inactive involves two steps: placing the mailbox on In-Place Hold or Litigation Hold, and then deleting the mailbox or corresponding Office 365 user account. After the mailbox is inactive, its contents are preserved until the hold is removed."



Freue mich auf Deine Rückmeldung.



Für weitere Fragen stehe ich gerne zur Verfügung.



Mit freundlichen Grüßen,



Desislava Dimova



Microsoft Office 365 Support Engineer

Bitte markieren Sie diese Antwort als ‚überprüft‘, wenn diese Ihnen weiterhelfen konnte, so dass auch andere Teilnehmer von der Lösung profitieren können. Die Teilnehmer, die die meisten Antworten zur Verfügung stellen, erhalten ein ‚Antwort-Abzeichen‘.