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

By umangka15 ·
Tags: Software
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums