How do I create a certain type of Excel formula?

D

Danny

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!
 
S

Stefi

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:
 
D

Danny

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.
 
D

Danny

Got it! Thanks.

Stefi said:
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:
Click to expand...
 
S

Stefi

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

„Carim†ezt írta:
 
Top