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 06: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 TMS; 03-10-2011 at 06:17 PM.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
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 TMS; 03-12-2011 at 01:05 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks