Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 16-03-2009
Member
 
Join Date: Aug 2006
Posts: 139
Calculating date in Excel

Hi!
on an excel sheet, the first column represents the date of departure on leave, the second term represent and I want the last automatically displays the date of resumption of work.
Thank you for helping me, I am a beginner
__________________
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little.
-Joe Martin
Reply With Quote
  #2  
Old 16-03-2009
Member
 
Join Date: May 2008
Posts: 4,829
Re: Calculating date in Excel

Format cell for departure and arrival dates = date
Format cell to Number = Number of days
In the arrival date you set your formula
(start date + number of days) And it works, I tested

Keep me informed

If indeed it does not work, look at the DateAdd function in helping, And if you really do not go away come again!
Reply With Quote
  #3  
Old 16-03-2009
Member
 
Join Date: Aug 2006
Posts: 139
Re: Calculating date in Excel

it works, thank you very much, in fact is that I had not changed the format of cells in "date." thank you again
__________________
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little.
-Joe Martin
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Calculating date in Excel"
Thread Thread Starter Forum Replies Last Post
Calculating Amount of Working day as per given month in Excel Abélard MS Office Support 2 21-02-2012 05:05 PM
Want excel 2007 to stop calculating processors AisleyP Windows Software 3 05-01-2012 04:48 PM
Problem calculating date Gunner 1 Software Development 5 23-02-2010 02:13 AM
Calculating Subtotal in Excel 2007 Simran Windows Software 3 22-10-2009 10:17 PM
Calculating Percentage Averages in Excel DANIEL 602 Windows Software 2 30-01-2009 01:10 PM


All times are GMT +5.5. The time now is 10:12 AM.