A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

CALCULATE FUTURE DATES



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old February 4th, 2004, 06:05 PM
Michael J. Malinsky
external usenet poster
 
Posts: n/a
Default CALCULATE FUTURE DATES

For example, the termination date is in A1, the number of severance days is
in B1. Use the following formula in C1:

=A1+B1

You may have to format the result into date format, but that should do the
trick.

--
Michael J. Malinsky


"Lynn" wrote in message
...
I need to calculate benefit and severance end dates from a given

employment termination date and do not know how to do it. For example:

Termination Date: February 13.
Employees receive 2 weeks severance/benefits per year of service, the

weeks range anywhere from 2 to 50. I do not know how to enter a formula to
calculate the severance/benefit end date.

Thanks for any assistance you can provide.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.