Adding # of days to a date

's Computer Specifications

I wish to add 125 days to todays current date format in a cell, to display in
date format, the date 125 days from now. Can anybody assist me with this?

's Computer Specifications

=A1+125
format as date

HTH
--
AP

"bastien86" <(E-Mail Removed)> a écrit dans le message de
news: EC2DE0B9-9AE3-4E8B-9B57-(E-Mail Removed)...
>I wish to add 125 days to todays current date format in a cell, to display
>in
> date format, the date 125 days from now. Can anybody assist me with this?

's Computer Specifications

=TODAY()+125

you might have to format the cell into a date.

"bastien86" wrote:

> I wish to add 125 days to todays current date format in a cell, to display in
> date format, the date 125 days from now. Can anybody assist me with this?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access Ver 2.0 Adding days to a date to give target date excluding weekends?	michael.nilsen@sgs.com	Microsoft Access Macros	1	30th Nov 2006 02:20 AM
Access Ver 2.0 Adding days to a date to give target date excluding weekends?	Michael	Microsoft Access Forms	2	19th Nov 2006 10:52 PM
Access Ver 2.0 Adding days to a date to give target date excluding weekends?	michael.nilsen@sgs.com	Microsoft Access VBA Modules	1	19th Nov 2006 01:06 PM
Adding a follow up date 10 days after current date	=?Utf-8?B?U3RhY3k=?=	Microsoft Word Document Management	2	26th Apr 2006 07:43 PM
adding work days to a begin date to derive the end date	Susan	Microsoft Access Queries	1	28th Oct 2004 05:53 PM