Thread: How do I convert from a julian date to a standard date mm/dd/yyy
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pdberger pdberger is offline
external usenet poster
  
Posts: 258
Default How do I convert from a julian date to a standard date mm/dd/yyy
Rosemary --

Here's something that might work:

A B
1 35 =DATE(YEAR(TODAY()),1,1)+A1-1

returns the answer of 2/4/2008.

HTH

"Rosemary" wrote:

can someone give me the formula for converting from a julian date to a
standard mm/dd/yy year formt
Reply With QuoteReply With Quote