Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Post Date Maniplation

Hi,

I want to find the difference in date from the below dates in the form

yyyy-mm-dd

Eg:

Start date = 1980-02-22
End date = 1966-11-29

Result should be in yyyy-mm-dd format.

Pl.help.

Thanks
Satish./
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,045
Default Date Maniplation

On Tue, 2 Apr 2013 15:51:52 +0000, Satishwin123 wrote:


Hi,

I want to find the difference in date from the below dates in the form

yyyy-mm-dd

Eg:

Start date = 1980-02-22
End date = 1966-11-29

Result should be in yyyy-mm-dd format.

Pl.help.

Thanks
Satish./


In Excel, "real" dates are stored as serial numbers with 1 = 1 Jan 1900. You can format the cell to display the date however you wish, including yyyy-mm-dd.

So to determine the difference between two dates, you merely subtract one from the other. That gives you a value in days, although you may have to change the format of the cell containing the formula.

However, you will need to be more specific as to how you want the results displayed. Days and weeks are simple. But since neither years, nor months have a fixed number of days, you will need to provide unambiguous details as to how you wish these computations to be made.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
date in Cell to change colors if the date is beyond today's date Pete Elbert Excel Discussion (Misc queries) 2 June 6th 09 06:31 AM
Making a date go red, if date passes todays date. Jamie Excel Worksheet Functions 2 September 9th 08 02:14 PM
Report Date - Date Recv = Days Late, but how to rid completed date MS Questionnairess Excel Worksheet Functions 1 January 25th 07 12:05 AM
copy date based on date -refer to date range mindpeace[_4_] Excel Programming 1 June 3rd 06 01:30 PM
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 04:00 PM


All times are GMT +1. The time now is 09:07 AM.

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

About Us

"It's about Microsoft Excel"