How do I create a certain type of Excel formula?
 

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!

How do I create a certain type of Excel formula?
 

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:

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!

How do I create a certain type of Excel formula?
 

Hi,

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

HTH
Carim

How do I create a certain type of Excel formula?
 

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.

"Stefi" wrote:

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:

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!

How do I create a certain type of Excel formula?
 

Got it! Thanks.

"Stefi" wrote:

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:

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!

How do I create a certain type of Excel formula?
 

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

€žCarim€� ezt Ã*rta:

Hi,

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

HTH
Carim