I want to check whether the day is friday, Saturday or sunday using Weekday(Dynamic) function and input a value automatically in a cell if the day is one of the above mentioned ones. Also i dont want it to change. Say for eg if the day is Friday, saturday or sunday I want a cell to show 1 and blank for rest days.
But if the cell value is 1 I dont want it to be blank again.
Can anyone help me out?
