Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
MaR MaR is offline
external usenet poster
 
Posts: 17
Default Working with dates previous 1900

I'm working in ancestry studies and I can not use dates previous to 1900 as
dates.
I need to use then in order to sort lines by born dates.
How cah I do?
--
Thank you very much
Mar
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default Working with dates previous 1900

See http://j-walk.com/ss/excel/usertips/tip028.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mar" wrote in message
...
I'm working in ancestry studies and I can not use dates previous to 1900
as
dates.
I need to use then in order to sort lines by born dates.
How cah I do?
--
Thank you very much
Mar



  #3   Report Post  
Posted to microsoft.public.excel.misc
MaR MaR is offline
external usenet poster
 
Posts: 17
Default Working with dates previous 1900

Thank you very much!
Very interesting function
Mar


"Bernard Liengme" wrote:

See http://j-walk.com/ss/excel/usertips/tip028.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mar" wrote in message
...
I'm working in ancestry studies and I can not use dates previous to 1900
as
dates.
I need to use then in order to sort lines by born dates.
How cah I do?
--
Thank you very much
Mar




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
Calculating time increments from dates during working hours S Davis Excel Worksheet Functions 0 October 24th 06 03:32 PM
Count dates for previous month [email protected] Excel Worksheet Functions 3 April 30th 06 08:40 PM
Working with dates Al Excel Worksheet Functions 3 April 21st 06 05:49 PM
can I format dates older than 1900 demangeo Excel Worksheet Functions 1 July 8th 05 12:55 AM
working with dates Phil kelly Excel Discussion (Misc queries) 2 June 21st 05 12:05 PM


All times are GMT +1. The time now is 01:17 PM.

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

About Us

"It's about Microsoft Excel"