Question

  • Creator
    Topic
  • #2137117

    To check if the day is friday using weekday and provide a cell value

    Locked

    by umangka15 ·

    Tags: 

    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?

All Answers

Share your knowledge