IF function

[AuDHDtism]

To start off I am wondering if the XL2BB app is user-friendly with Mac? Because I am having issues with the useability with an XL. I am not able to use the mini sheet or table only functions that are within the app on excel. As I do believe the individuals trying to help me with my formulas would be much better off being able to see what exactly I am looking for in order to take in the able to help me best. As for my equation, I am looking to check if H5 [which is a checkbox]=TRUE,I want to list a date including data from D5=DAY and Z2=Month. I want to have a weekday function in it so I can have it listed as close to the day but in weekday.

Formula I've used:
=IF(H5=TRUE,DATE(2024,Y2,IF(D5=WEEKDAY(E5,1),,"")),"")

 

[etaf]

i use xl2bb on a macbook, excel 365 , and i have not updated to the lates OSX yet, still on Ventura
works fine, although i did have issues back in 2017 when i statred on old macbook, but this new one from last year it installed and worked fine

note
You can also test to see if it works ok, in the "Test Here" forum.

Test Here

Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc. Threads in this forum are automatically deleted after no replies for seven (7) days

www.mrexcel.com

OR if you cannot get XL2BB to work, or have restrictions on your PC

then put the sample spreadsheet onto a share

I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed

Make sure you set any share or google to share to everyone

i'll reply to question in new post

 

[etaf]

D5=DAY and Z2=Month.
is month in numbers , 01.02 etc or just 1,2,3,4 - OR in text Jan,Feb,Mar etc

your formula has Y2 and E5
whats Y2

I want to have a weekday function in it so I can have it listed as close to the day but in weekday.

so if a saturday , then you want Friday or Monday
same question for a sunday

 

[felixstraube]

So you basically want this input / output (building the input date from the cells as DATE(2024;$Z$2;$D$5)?

(Sorry my excel is in spanish, sá is saturday, do is sunday)

Input date	Output date
04/11/2024 lu	04/11/2024 lu
05/11/2024 ma	05/11/2024 ma
06/11/2024 mi	06/11/2024 mi
07/11/2024 ju	07/11/2024 ju
08/11/2024 vi	08/11/2024 vi
09/11/2024 sá	08/11/2024 vi
10/11/2024 do	11/11/2024 lu
11/11/2024 lu	11/11/2024 lu
12/11/2024 ma	12/11/2024 ma
13/11/2024 mi	13/11/2024 mi

So you go back or forward in time to the closest working day? Or you want to go always into the future from you input date?

 

[AuDHDtism]

This page is set up as the following:
B3:E3 is Other Chore Titile: under that is heading on top of columns (Column B is Area),( Column C is Chore), Column D is Desired day of month I'd like to complete the tasxk on), Column E is desired weekday I'd like the chore done on.
H4:S4= months in abbreviated form Jan, Feb, ZMar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov, Dec, all with check boxes H5:S35.
Then we have list of the months with the specific chores to be done from the checkboxes.
So, U2:W2 is January and I want to pull the data to make a date so that I have :
=IF(H5=TRUE,DATE(2024,U2,D5)
but i want this formula to include the desired weekday.

 

[felixstraube]

I do not quite understand what you want. Can you maybe upload your file to google drive or similiar o pase the BB code here?
And add the list of days / desired days and the result you want in each case?

 

[AuDHDtism]

Here is a screenshot for reference.

 

[AuDHDtism]

Other Chores

Activate on which month

January

Area

Chore

Desired Due Date

Desired Weekday

#

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Target Date

###​

1

1

##

##

##

##

##

##

##

##

##

##

##

##

Mon, Jan 1

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

0

##

##

##

##

##

##

##

##

##

##

##

##

###

 

[Peter_SSs]

I am not able to use the mini sheet or table only functions that are within the app

Is this the issue that you are having with XL2BB?