Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yves
 
Posts: n/a
Default Calculate due date from a starting day

Starting day is f ex 15/06/2006. I Have to calculate 35 day's later.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default Calculate due date from a starting day

Say 15/06/2006 is in A1.
Enter:
=A1+35
and format as date


HTH
--
AP

"Yves" a écrit dans le message de news:
...
Starting day is f ex 15/06/2006. I Have to calculate 35 day's later.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How to get the Excel to calculate the exact date from a given date Phil Excel Worksheet Functions 10 April 28th 06 07:07 PM
Auto calculate for date + days forward to yield new date John Sullivan Excel Worksheet Functions 1 April 22nd 06 05:18 PM
How to calculate "number of months" between two given date? nginhong Excel Worksheet Functions 23 April 17th 06 02:47 PM
formula to calculate age using birth date and current date lalah Excel Worksheet Functions 2 November 20th 05 10:51 PM
how to calculate a date .. say 34 days from today shaunl Excel Discussion (Misc queries) 5 July 13th 05 02:38 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"