To obtain current day's value

Muthukrishnan V

Board Regular
Joined
May 29, 2008
Messages
179
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
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,432
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
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
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,432
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
You're welcome
 

Watch MrExcel Video

Forum statistics

Threads
1,114,421
Messages
5,547,823
Members
410,813
Latest member
Vhinzvirgo
Top