Forum Discussion
2 workbooks - trying to get formula to update workbook 1 from workbook 2 based on today's date.
Hi All. Really stuck. As stated I have 2 separate workbooks. Workbook 1 has a table with 365 days listed in column A. In column B I need a formula that picks up data entered into Row 6 of wo...
Can any one explain why when i put today(-1) when false it does not work?
=IF(A:A=TODAY(),(0),Today(-1),INDEX('[NDG 2018 Calendar.xlsm]Calendar'!$6:$6,MATCH(9.99999999999999E+307,'[NDG 2018 Calendar.xlsm]Calendar'!$6:$6)))
=IF(A:A=TODAY(),(0),Today(-1),INDEX('[NDG 2018 Calendar.xlsm]Calendar'!$6:$6,MATCH(9.99999999999999E+307,'[NDG 2018 Calendar.xlsm]Calendar'!$6:$6)))