What formula do I use to add to a date column in Excel?

Donna at CMS

Posts: n/a

What formula do I use to add to a date column in Excel?

Help! We have a date in the format 01/01/2000 in column A1. We need to
produce a date in column B1 that is five years on minus one day (i.e.
31/12/2005). Does anyone know of a way to do this?

Many thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
Format an excel column as a date for a 5 day week for a year.	dabenesch	Excel Discussion (Misc queries)	1	December 30th 04 02:45 PM
Converting an Excel formula to an Access query formula	Adam	Excel Discussion (Misc queries)	1	December 15th 04 03:38 AM
In Excel, I need a date math formula...	Lisa	Excel Discussion (Misc queries)	2	December 3rd 04 12:13 AM
How do I sort a column of formulas in Excel?	Gordon	Excel Discussion (Misc queries)	2	November 27th 04 01:55 AM

All times are GMT +1. The time now is 11:30 AM.

Menu

About Us