Calculate date so many days before/after current date.

Posted to microsoft.public.excel.misc

Jake[_6_]

external usenet poster

Posts: 17

Calculate date so many days before/after current date.

I would like to take a date in A1 and in A2 have a set number of days from
that date. In A3 will be shown the date which is A2 days before/ahead of A1.

Example: A1 = 22-Jan-12, A2 = 5 and A3 will be calculated automatically as
27-Jan-12.

Obviously this is an oversimplified result, my idea is to calculate many
thousands of days ahead and before set specified dates.

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
I want any date 90 days or older from current date change color	Big Abalone	Excel Worksheet Functions	5	April 23rd 06 05:01 AM
Auto calculate for date + days forward to yield new date	John Sullivan	Excel Worksheet Functions	1	April 22nd 06 05:18 PM
formula to calculate age using birth date and current date	lalah	Excel Worksheet Functions	2	November 20th 05 10:51 PM
formula to calculate future date from date in cell plus days	Chicesq	Excel Worksheet Functions	8	November 3rd 05 12:25 PM
Calculating days between current date and a date in future NETWORKDAYS() function	Faheem Khan	Excel Worksheet Functions	2	February 10th 05 07:18 PM

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

Menu

About Us