Hello,
Need a formula in cell O3, which chose nearest last date from yellow highlighted cells and reflect in cell o3.
For example, if sheet open today, in cell O3, date should show Nov 1- 2013, if opened on nov 07,2015, date in O3 should show NOv -1-2015.
Thanks.
SB
Try this...
=HLOOKUP(TODAY(),J3:N3,1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
=MAX(IF(J3:N3 < TODAY(), J3:N3))
The formula MUST be confirmed with Crl+Shift+Enter rather than just Enter.
Entia non sunt multiplicanda sine necessitate
shg, thanks for the feedback
shg, FDibbins, thanks for your help. it worked.
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks