Happy to hear that, do subscribe to my channel if you haven't already and enable notifications for updates. Best Regards, Syed H I MyKnowledgePortal.com
Thanks Syed. This helped me to count certain days from an excell sheet. I couldn't understand why it didn't count, but after I saw the istext/ is number explanation I managed to use numbers instead of day and wala it worked!!! Thanks Man
1 question - if i put dddd, it defaults to Sunday=1, how do i then start the text version of the week with monday i.e. i've used =weeekday(c2,2) format but text isn't reflecting. thanks for this, very helpful
What do you mean as a proper date... I have it as a proper date and it's not working. I'm trying to use weeknum and its giving me a date in the 1900s instead of a week number
@@Syedhussainipage I think i figured out this particular issue. What I can't seem to do is be able to filter the date in tabs by different criteria. I'm trying to do a weekly, bi-weekly, monthly and yearly type situation but I can't find a single tutorial or formula.
@@futuresuperstar4life Thank you for letting me know that. If you could share a sample data, I can take a look at it and see how we can achieve it. Use this form to submit your sample data file forms.gle/CxaWGeqdugMktWPx6 Best Regards, Syed H
The weekday function is not working for me, no matter what I do. I tried formatting the return cell value with General and Numbers but the cell keeps returning the error code #Value!. This is how I type the function, on the right side of the date column I typed; =WEEKDAY(A3,2) Result shows #VALUE!. I need help, can it be my excel worksheet settings? I'm using MS Excel 2021
@@dandan9175 please let me know what is in the A3. Also, if you can please share a copy of your data as a sample for my reference. Use this form to share sample file forms.gle/DGXWd7Cc9u11GPao9
Hello I have a data which consist of dates in format 01/01/2022 like that, I need to sum the value of corresponding day example like sunday monday... Can you please help.. Ex: the number of items sold in weekends but the provided format is dd-mm-yyyy when I try to use weekday and =text convert to day it showing wrong values How to overcome this problem... Please help..
I have a question if anybody could please help me with it, I need a column of each Wednesday of the week, if I put one day and drag it, I get every single date, I just specifically want the one day being my payday and also I would like the first of every month as well
Great video Syed. Do you happen to know if the same weekday( ) return type chart you show at 1:54 works in Google Sheets as well? For instance, could I enter "15" for the return type and shift the start day to Friday in Google Sheets? Thanks in advance! I find your content very helpful.
Why doesn't Excel just fill in the value Tuesday automatically in the example? Why make us go through the trouble of custom formatting? It's safe to assume someone using the WEEKDAY function doesn't want the result displayed as a number even though that's how Excel sees it.
I am sure there is a good reason behind this. The numbers are more friendly when it comes to calculations than text, and that could be the reason behind this. 🧐
Hello Bunai, Order numbers are independent from dates and are randomly generated numbers for demonstration. Let me know if you face any issues. Regards, Syed H
I have created this function to get first date of week as Thursday in ms access form and reports, but this function return first day of week in las month, but I need it will return only current month dates, if current week first day is in last month then retrun first day of week as 1st date of week in current month. ‘current output ‘when 1-10-2018 is selected from date picker it returns 27-09-2018, which is first date of week in last month but I need it will return 1st of month which is selected in textbox. Function GetFirstofWeek(dtDate As Date) 'GetFirstofWeek = DateAdd("d", dtDate, -(Weekday(dtDate)) + 1) ' Excel formula for this function which is perfect and may be converted to function as required ‘=MAX(B2-WEEKDAY(B2,14)+1, EOMONTH(B2, -1)+1) GetFirstofWeek = DateAdd("d", dtDate, -(Weekday(dtDate, vbThursday) - 1)) End Function 'For last day of week Function GetLastofWeek(dtDate) as date '=MIN(B2+(7-WEEKDAY(B2,14)), EOMONTH(B2, 0)) GetLastofWeek = DateAdd("d", dtDate, (7 - (Weekday(dtDate, vbWednesday)) + 1)) End Function In this function last date of week must be in current month, if month end on first date of then week will be closed and last date of week will be 1st date of week or days remaining in current week.
need to know what is the total number of workdays between two dates - why would one need to know what day a date is?Your description is not aligned with you video!!!!
sorry for very delayed response. I guess you were looking for ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-x7aJ1aJcVuo.html Please let me know if you are still looking for any help.
I have question to ask, I want to display first and day of week, week starts from Thursday to Wednesday, if the start date of month is on tuesday then first date of week will be tuesday of the current month, same case on last date of week, if week ends on monday then last date of week will be monday of only in current month, without going to next month last week day. Out expected For last month 1-09-2018 to 05-09-2018 27-09-2018 to 30-09-2018 For current month 1-10-2018 to 3-10-2018 4-10-2018 to 10-10-2018 11-10-2018 to 17-10-2018 18-10-2018 to 24-10-2018 25-10-2018 to 31-10-2018
Dear Ashfaq, Here is what you should do to have a custom start day for the week. Set the value 14 in place of the return_type to begin your week from Thursday. See this link goo.gl/AwwKg9 for more details. Hope you find this helpful. Best Regards, Syed H
@@Syedhussainipage I have created this function to get first date of week as Thursday in ms access form and reports, but this function return first day of week in las month, but I need it will return only current month dates, if current week first day is in last month then retrun first day of week as 1st date of week in current month. ‘current output ‘when 1-10-2018 is selected from date picker it returns 27-09-2018, which is first date of week in last month but I need it will return 1st of month which is selected in textbox. Function GetFirstofWeek(dtDate As Date) 'GetFirstofWeek = DateAdd("d", dtDate, -(Weekday(dtDate)) + 1) ' Excel formula for this function which is perfect and may be converted to function as required ‘=MAX(B2-WEEKDAY(B2,14)+1, EOMONTH(B2, -1)+1) GetFirstofWeek = DateAdd("d", dtDate, -(Weekday(dtDate, vbThursday) - 1)) End Function 'For last day of week Function GetLastofWeek(dtDate) as date '=MIN(B2+(7-WEEKDAY(B2,14)), EOMONTH(B2, 0)) GetLastofWeek = DateAdd("d", dtDate, (7 - (Weekday(dtDate, vbWednesday)) + 1)) End Function In this function last date of week must be in current month, if month end on first date of then week will be closed and last date of week will be 1st date of week or days remaining in current week.