Hi
In cell A3, I have a start date of: 12/08/14
In cell A4, I have an estimated number which represented the estimated weeks needed
I'm looking for a formula that can provide the end date based estimated weeks given.
Thanks
Hi
In cell A3, I have a start date of: 12/08/14
In cell A4, I have an estimated number which represented the estimated weeks needed
I'm looking for a formula that can provide the end date based estimated weeks given.
Thanks
Last edited by mycon73; 12-07-2014 at 11:46 PM.
MyCon
-- Using Latest Version of Excel
Hi
Will this work =A3+(A4*7)
Regards.
Try this...
=A3+(A4*7)
Format as Date
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi Bobsone & Tony Valko,
I figured it would be something simple. I must be tired & kind of brainless at the moment.
Both examples given work great!!!
Thanks
Hi Bobsone & Tony Valko & Others,
Now that I see this "simple" answer, how can this be modified to show a Week Ending Friday or Sunday's date?
This function in another cell works well for getting a week ending Sunday & I'm thinking I want a variation with this to be combined with your suggested example.
=A4-WEEKDAY(A4,2)+7
Thanks
Hi
I have loaded a simple sheet, is it what you are looking for?
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks