• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Days

D

DaveNJ0124

New Member
I want to take a date say 1/22/13 and find the date 45 days from it. In addition to this formula is there a way to use the Julian date say 022 and add 45 days and cell will populate with the date?
 
Hi Dave ,


Dates are just numbers , and you can add dates the way you would add numbers ; if your date is in cell A1 , then in B1 , if you put a formula such as =A1+45 , you will see the resulting date in B1.


A date is a number starting with 1/1/1900 i.e. the number 1 formatted as a date will show the date 1/1/1900 , and hence adding 22 and 45 will not give you the date you want ; it will give you 67 days from 1/1/1900 i.e. 3/7/1900.


Narayan


P.S. The following links give a lot of information on Julian dates in Excel :


1. http://office.microsoft.com/en-in/excel-help/insert-julian-dates-HP003056114.aspx


2. http://www.cpearson.com/excel/jdates.htm


3. http://excel-formulas.blogspot.in/2005/08/julian-calendar-date-conversion.html
 
You must log in or register to reply here.
Back
Top