Cell A1 contains a number, which is the number of days.
Cell D6 has a date entered.
The next cell along (E6) I want to have it show the figure in A1 added to the date in D6.
The figure in A1 can change. I want to be able to change this figure and the date in E6 will change accordingly.
Can this be done? Please advise.
Thanks.
Last edited by Dave Goldman; 03-10-2011 at 05:23 PM.
E6 formula: =D6+A1 formatted as a date
A date is simply a number, that number being the day number starting with 01/01/1900 (day 1).
Today, 10 March 2011, is day 40612.
Regards
Last edited by TMShucks; 03-10-2011 at 05:17 PM.
Cell A1 has date, I need to appear automatically in cell A2 the date + 15, Exampal when I print in cell A1 the date 01-Mar-2011, in cell A2 automatically appear 15-Mar-2011.
Right now I do this =sum(cell A1+15) but remaining all cells this type of date appear 15-Jan-00 please solve this with suitable formula
Really, you should start your own thread.
However:
=A1+14 will give you 15 March 2011 ... you will need appropriate formatting
Regards
Last edited by TMShucks; 03-12-2011 at 12:05 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks