To obtain current day's value

Muthukrishnan V

Active Member
Joined
May 29, 2008
Messages
269
Office Version
  1. 365
Platform
  1. Windows
Office 365

Sheet1 Column A6:A55 contains dates in DD-MM-YYYY format in
chronological order. Presently this A25 contains date 03-09-2020, i.e. today.

Sheet1 Column B6:B55 contains numbers in numerical format and
the number is filled in on daily basis. Therefore as of today B6:B25 have
been filled. B26:B55 are bank and will be filled in future.

My requirement: Cell Sheet2!C15 should show sheet1!B25 (Today's entry).
(Tomorrow this Cell sheet2!C15 should show sheet1!B26)

I request you to kindly advise me the formula in Cell Sheet2!C15.

Thanking you
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
If your dates are exact dates (i.e. no time part) then you can just use an index/match
Book1
C
1535
Sheet2
Cell Formulas
RangeFormula
C15C15=INDEX(Sheet1!$B$6:$B$55,MATCH(TODAY(),Sheet1!$A$6:$A$55,0))

Book1
AB
5
615/08/202016
716/08/202017
817/08/202018
918/08/202019
1019/08/202020
1120/08/202021
1221/08/202022
1322/08/202023
1423/08/202024
1524/08/202025
1625/08/202026
1726/08/202027
1827/08/202028
1928/08/202029
2029/08/202030
2130/08/202031
2231/08/202032
2301/09/202033
2402/09/202034
2503/09/202035
Sheet1
 
Upvote 0

Forum statistics

Threads
1,213,501
Messages
6,114,010
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top