Convert a Date to DAY of the week

Post Reply
BobFormby
Posts: 2
Joined: Thu May 13, 2021 9:22 am

Convert a Date to DAY of the week

Post by BobFormby »

I want to use an =IF function to display certain text if the date in a cell is a Sunday.

=IF(A2="Sun","Closed","")

The DATE functions do seem very limited compared to Excel.
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 2935
Joined: Wed Mar 11, 2020 5:31 pm

Re: Convert a Date to DAY of the week

Post by SuperTech »

The function you mentioned in your post is actually comparing strings and not day of the given date. To achieve Sunday as closed, please use this function:

Code: Select all

=IF(WEEKDAY(A2)=1,"Closed","")
Assuming, by default, Sunday as the first day of the week.
Post Reply

Return to “PlanMaker 2021 for Windows”