| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I subtract today's date from one before 1900?
I'm attempting to create an Excel timeline of battles and major eveins in
United States history. I want one of the column's to show how many years it has been since that date. For example, say A6 has July 4, 1776. Cell A1 has the formula =Today() Every time I use the formula =Year(A1)-Year(A6) I get an error message in the cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum a range if the date is is greater than today's date? | Excel Worksheet Functions | |||
| Setting traffic lights based on todays date against target dates | Excel Discussion (Misc queries) | |||
| Activating "Todays Date" column upon opening? | Excel Discussion (Misc queries) | |||
| calculate no. of years between a date and today's date | Excel Worksheet Functions | |||
| Subtract a group of cells from a total based on ending date | Excel Discussion (Misc queries) | |||
Threaded Mode
