Hi,
I have a list of dates and I need to adjacent column to return the date + a specified number of days indicated on another tab. Example attached, see comment in cell F4 for details.
Many Thanks,
Matt
Hi,
I have a list of dates and I need to adjacent column to return the date + a specified number of days indicated on another tab. Example attached, see comment in cell F4 for details.
Many Thanks,
Matt
Last edited by MjRmatt; 03-30-2011 at 08:28 AM.
Try:
=E4+SUMIF('Cert Date'!$A$2:$A$5,A4,'Cert Date'!$C$2:$C$5)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
try =E4+VLOOKUP(A4,'Cert Date'!$A$2:$C$200,3,FALSE)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks guys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks