Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 8

Subtracting 1 year from todays date

Does anyone know how to subtract from or add to the year in a given date e.g
if today's date is 28 Sep 07 I would like to be able to add 1 and subtract 1
to the year only giving 28 Sep 06 and 28 Sep 08. If I do minus 365 it will
work, but not on leap year dates.

Thanks

Alan

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
Todays date	Kevin	Excel Discussion (Misc queries)	3	May 19th 07 08:19 PM
Todays date	rexmann	Excel Discussion (Misc queries)	5	January 12th 06 03:18 PM
Create a button that will date stamp todays date in a cell	Tom Meacham	Excel Discussion (Misc queries)	3	January 11th 06 01:08 AM
When I open my past invoice it keeps changing date to todays date	Stop date changing to todays in Excel	Excel Worksheet Functions	2	October 7th 05 04:54 PM
I want todays date in my spreadsheet to be red. I also want this.	Leah Wright	New Users to Excel	1	April 14th 05 03:04 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us