How do I create a certain type of Excel formula?

[Guest]

I need to create a formula for excel and I don't know how. Basically what I
need the formula to do is I plug in a date and I need the formula to show me
what day is the deadline for a task. Example: I have personnel that have to
have a certification by the 75th day of work and I want to be able to plug in
their start date and I want the formula to show me what date the 75th day
would be. Thanks for any and all help!

 

[Guest]

Say start day is in A1, duration (75 days) is in B1, then enter in C1 =A1+B1
and format it as date!

Regards,
Stefi

„Danny†ezt írta:

 

[Carim]

Hi,

=WORKDAY(A1,75)
if cell A1 is the start date

HTH
Carim

 

[Guest]

OK I'm not tracking. Can you walk me through it a little more please. I
have very little experience with making formulas in Excel.

 

[Guest]

Got it! Thanks.

Say start day is in A1, duration (75 days) is in B1, then enter in C1 =A1+B1
and format it as date!

Regards,
Stefi

„Danny†ezt írta:

 

[Guest]

Yes, but Danny forgot to specify wether he meant calendar days or workdays!
Regards,
Stefi

„Carim†ezt írta: