Thread: Dates again
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
excelFan excelFan is offline
external usenet poster
 
Posts: 53
Default Dates again

Is it there a way to substract 2 cells with different dates and get a result
in year,months and days.
WAIT! not that easy:
The second date (B1) could be today or close as in 1900, 2000...
The first date(A1), that's the one giving me the problem
because it could be in 1776, 1492 etc.
THANKS.