Calculate the day number when day one is 28th or 29th February 1852

[Chris Waller]

I am trying to create a date number generator in Excel, however day 1 is 28th or 29th February 1852 (28/02/1852). not that I need to calculate something of that age, however, to be able to work with a more realistic dates I need to know the date numbers going forward. I also would like to be able to input a day number and for it to return the date. I don’t know where to start and would appreciate some help. TIA. A WebApp was mentioned, but I currently do not have the knowledge to be able to work that one out either. TIA

 

[Dryver14]

today is 42384

 

[Dryver14]

if you type a date in excel then format as general it will give you the number

 

[Chris Waller]

today is 42384

Driver14. Thanks for that , but I believe you may be wrong. The only reason I say that is because I was told that the 13th January 2016 is 59854. Thanks once again.

 

[mole999]

two date systems in excel 1900 and 1904, before that dates are meaningless, so 1852 is out. There are work arounds but don't manipulate in the normal excel fashion
1900 produced 42385 and 1904 = 40923

 

[dckmob]

I was told that the 13th January 2016 is 59854.

59854 equals 14th November 2063

 

[Chris Waller]

two date systems in excel 1900 and 1904, before that dates are meaningless, so 1852 is out. There are work arounds but don't manipulate in the normal excel fashion
1900 produced 42385 and 1904 = 40923

mole999, Thanks for your help. I have managed to come up with a formula to calculate the date number. Thanks again.