IF with OR and Today Functionality

Shinianne

New Member
Joined
Aug 6, 2018
Messages
24
Office Version
365
Hi,

Is it possible to associate =today() to if

this is an example: the current tab i'd like for it to change from EMEA to AMER if today the work time is 10 PM onwards and be change to EMEA if the shift was changed to 5PM, is that possible can i kindly ask for help please thank you

AbsentAB
Vacation LeaveVL
Half DayHD
Adjusted
6-May7-May8-May9-May10-May11-May12-May13-May14-May15-May16-May17-May18-May19-May20-May21-May22-May
NAMELEADStatusCURRENTNEW INOUTMondayTuesdayWednesdayThursdayFridaySaturdaySundayMondayTuesdayWednesdayThursdayFridaySaturdaySundayMondayTuesdayWednesday
BillableEMEAEMEA5:00 AM2:00 PM5AM5AM5AMRDRD5AM5AM5AM5AM5AMRD3PM3PMRD3PM3PM3PM
BillableAPACEMEA5:00 AM2:00 PM5AM5AM5AM5AM5AMRDRD5AM5AM5AM5AMRDRD3PM3PM3PMRD
BufferAPACEMEA5:00 AM2:00 PM5AM5AM5AM5AM5AMRDRD6AM6AM6AM6AM6AMRDRD4PM4PM4PM
BillableAPACEMEA5:00 AM2:00 PM5AM5AMRD5AMRD5AM5AM5AM5AMRD5AM5AMRD5AM3PM3PM3PM
BillableAPACEMEA6:00 AM3:00 PM6AM6AM6AM6AM6AMRDRD5AM5AM5AM5AM5AMRDRD4PM4PM4PM
BillableAPACEMEA7:00 AM4:00 PMRDRD7AM5AM5AM5AM5AMRD2PM2PM2PM2PM2PMRD2PM2PM2PM
BillableAPACEMEA7:00 AM4:00 PMRDRD7AM7AM7AM7AM7AMRD3PM3PM3PM3PM3PMRD3PM3PM3PM
BillableAPACEMEA7:00 AM4:00 PM7AM7AM7AM7AM7AMRDRD7AM7AM7AM7AM7AMRDRD4PM4PM4PM
BillableAPACEMEA7:00 AM4:00 PM7AM7AMRDRD7AM7AM7AM7AMRD7AM7AM7AM7AMRD3PM3PM3PM
BillableEMEAAMER2:00 PM11:00 PM2PM2PM2PM2PM2PMRDRD2PM2PM2PM2PM2PMRDRD8PM8PM8PM
BillableEMEAAMER2:00 PM11:00 PM2PM2PM2PM2PM2PMRDRD2PM2PM2PMRDRD11PM11PM11PM11PM11PM
BillableEMEAAMER2:00 PM11:00 PM2PM2PM2PM2PM2PMRDRD2PM2PM2PM2PM2PMRDRD8PM8PM8PM
BillableEMEAEMEA2:00 PM11:00 PM2PM3PM3PM3PM3PMRDRD2PM2PM2PM2PM2PMRDRD2PM2PM2PM
BillableAMERAMER2:00 PM11:00 PM2PM2PM2PM2PM2PMRDRD8PM8PM8PM8PM8PMRDRD8PM8PM8PM
 

Panda514

New Member
Joined
Mar 11, 2019
Messages
37
Hello,

I think I figured out what you need. I would suggest adding a cell that says Today's Date somewhere on your sheet and using the Today() function to automatically update the date each time you open the workbook. In my example below, Today is in A1 and =TODAY() is in B1. Current is in A3. I set the formula to see if the date in cell B1 matches the date in row 3 and the return value is 10PM then it will give the New column AMER. If not then it will use the current value as the new value.

Today6/10/2019
CurrentNew6/9/20196/10/2019
EMEAAMER9PM10PM
EMEAEMEA7PM8PM

<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>

CurrentNew6/9/20196/10/2019
EMEA=IF(INDEX($C:$D,MATCH($B$1,$3:$3,0)*0,2)="10PM","AMER",A4)9PM10PM
EMEA=IF(INDEX($C:$D,MATCH($B$1,$3:$3,0)*0,2)="10PM","AMER",A5)7PM8PM

<tbody>
</tbody>
 

Forum statistics

Threads
1,085,369
Messages
5,383,233
Members
401,818
Latest member
MrMisster

Some videos you may like

This Week's Hot Topics

Top