Dear all,
Good day !!!
supposing i have a1 , a2 , a3 cell contains as date 5th sep 2020 then a4 , a5 , a6 contains date value 6th sep 2020 and so on. i want a formula based on date that gives corresponding day in adjacent another cell.
ex: by formula B1,B2,B3 should gives saturday then B4, B5, B6 gives sunday and so on based on date a1, a2 , a3 etc.
Please assist.
rgds,
aligahk06
Good day !!!
supposing i have a1 , a2 , a3 cell contains as date 5th sep 2020 then a4 , a5 , a6 contains date value 6th sep 2020 and so on. i want a formula based on date that gives corresponding day in adjacent another cell.
ex: by formula B1,B2,B3 should gives saturday then B4, B5, B6 gives sunday and so on based on date a1, a2 , a3 etc.
Please assist.
rgds,
aligahk06