If the date is a weekday then...

Hey everyone,

This is my first post so, my apologies if there are any faux pas. I'm trying to do an IF function involving the date.

Basically if the current day is a weekday then I want the cell value to be 30. If the current date is a weekend then I want the cell value to be 50. I'm pretty lost on how to write the formula so any help would be much appreciated

Thanks for your time

Here, try this:

=IF(WEEKDAY(A1,2)>5,50,30)

where A1 is your date

Or this if you looking for TODAY()

=IF(WEEKDAY(TODAY(),2)>5,50,30)

Try

=IF(WEEKDAY(TODAY(),2)<6,30,50)

Your post does not comply with Rule 6 of our Forum RULES. Common courtesy is the order of the day. Avoid coarse language, provide feedback to suggested solutions, and take the time to thank those who took their time to help you.