*Try this also:*
*
*
*Formula in A1 is =NOW()*
*
*
*Formula in A2 is*
*
*
*=IF(WEEKDAY(IF(WEEKDAY(A1,2)=6,A1+2+TIME(0,5,0),IF(WEEKDAY(A1,2)=7,A1+1+TIME(0,5,0),A1+TIME(0,5,0))),2)
= 6,
IF(WEEKDAY(A1,2)=6,A1+2+TIME(0,5,0),IF(WEEKDAY(A1,2)=7,A1+1+TIME(0,5,0),A1+TIME(0,5,0)))+2,IF(WEEKDAY(IF(WEEKDAY(A1
I want to add time to a particular date and time by 5 minutes in every
subsequent cell. The time range should be between 10:00 AM to 5:00 PM. I.e.
after 5:00 PM the date should be changed to next day 10:00 AM. And the day
range will be Monday to Friday. i.e. if it’s a Saturday or Sunday it shou
