Forum

Notifications
Clear all

Help needed

3 Posts
2 Users
0 Reactions
90 Views
(@salim-gul)
Posts: 33
Trusted Member
Topic starter
 

Hi

Dear  Mynda Treacy 

hope you will be fine

I have learned lot of things from your this plate form, thanks for it, here is a request for guidance about few problems, first one is that how can I separate working days and holidays from whole month especially Saturday and Sunday automatically update, second one is that how can I add sing with answer positive and negative with sign of up and down in one cell for you kind understanding I have attached sheet for 

 
Posted : 08/12/2021 5:59 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Salim,

If you have Microsoft 365, you can use the FILTER function with the SEQUENCE function to create a list of weekday dates. And you can use custom number formats to put the symbols in the cells. See attached.

Mynda

 
Posted : 08/12/2021 7:00 am
(@salim-gul)
Posts: 33
Trusted Member
Topic starter
 

Hi 

Madam Manda T

Hope you will be fine

I am very thankful you for cooperation & hope you will guide me in future, thank you very much

regards 

Salim Gul 

 
Posted : 09/12/2021 2:53 am
Share: