Converting Earth's history into a year-long calendar

[janenelson]

Hello -

I don't use Excel often and my assignment for one of my courses includes taking the history of the Earth (in billions/millions/thousands of years) and converting that time into a year-long calendar. How would I do this?

Thanks!

[Pete_UK]

You can use this formula in C3:

=365/$B$2*($B$2-B3)+$C$2

Format as a date, then copy into cells C4:C28

Hope this helps.

Pete