There are a variety of functions to work with days in Excel. The day of week function (WEEKDAY) is particularly useful for planning and scheduling, for example to determine the timeframe of a project and automatically remove weekends from the total. Continue reading
Comments page 2. Total comments: 284
I have created a project schedule with conditional formatting to show week day and weekends - which works perfectly. Each task has a set duration (of workdays) before the final product. I currently have it formatted and coded so I input the due date and it plans backwards using the duration's set for each task.
This however does not exclude weekends, how do I use excel to automatically update the number of days if a weekend falls in that space?
IE if a task takes 5 days but day 3 and 4 are weekends the task would update to take 7 days? Is this even possible?
My aim is to then use that data as a bar graph so the schedule automatically grows/shrinks based on the user inputted requested end date.
Hello!
To add days to a date, including weekends, use the WORKDAY and NETWORKDAYS functions.
This should solve your task.
Request your help in below scenarios
1. If my month start with Monday then from Monday to Sunday to be marked with Week1 Next Monday to Sunday will be Week2 next Monday to Sunday will be Week3 next from Monday to till end of month to be marked as Week3
2. If month doesn't start with Monday then from day 1 to 2nd Sunday of the month to be marked as week1 next Monday to Sunday to be marked as week2 next Monday to Sunday to be marked as week3 next Monday to end of the month as week4
I'm SUPER new to this!
I'm trying to figure out how to show a Weekday, Month, Day of the Month, & Year (Wednesday July 13, 2022) by entering 7/13/22 in a cell.
I have it in one now. But if I copy & paste it, it shows the date that I copied. I need it to be blank, so I can enter a numeric date, then it transposes it to the format I mentioned above.
Something for a cell to select an AM/PM time of day too, would be appreciated!
PLEASE & THANK YOU!
Hello!
Enter the date in the cell and then set the custom date format as you need. You can find the examples and detailed instructions here: How to change Excel date format and create custom formatting. I hope it’ll be helpful.
Good day.
I would like to count the days in a range.
eg.
(a1) july 7, 2022 - (a2) july 9, 2022
(b1) july 8, 2022 - (b2) july 10, 2022
Results should be:
Thursday - 1
Friday - 2
Saturday - 2
Sunday - 1
Thanks
Hi!
You want to count the days of the week when only the first and last date in a date range is specified. I'm really sorry, looks like this is not possible with the standard Excel options.
Hello!
Seeking your kind assistance. I need to separate the sum of the Monday to Friday sales from the weekend sales per week of the month for the whole year. Is there an easier way to do this other than sum function?
Hi!
To find a conditional sum, use the SUMPRODUCT function.
=SUMPRODUCT(--(WEEKDAY(A1:A100,2)<6),B1:B100)
I hope my advice will help you solve your task.
Thank you Mr. Trifuntov!
Be careful!
=DAYS(01/07/2022,01/08/2022) gives 31, the number of days in July, so this is BETWEEN the dates: 01/08/2022 not being counted.
=NETWORKDAYS(01/07/2022,01/08/2022) gives 22. that is the number of workdays in July 2022 plus the Monday 1 August 2022. So, in the NETWORKDAYS (and NETWORKDAYS.INTL) the end-date is included in the period.
Be aware of this if you have to calculate the workdays in a period as a fraction of the number of days in that period, this can be dealt with by simply adding 1 to the DAYS function.
Hi!
Keep in mind that the date 01/08/2022 actually means 01/08/2022 00:00:00 in Excel and does not include that day. We have written about this many times in our blog.
Thanks, but that's not really the issue here (and indeed well known); the issue is that the NETWORKDAYS function does include the end-date in the evaluation of workdays, which at least is inconsistent with the DAYS function.
Hi!
It is not possible to set an Excel filter on the days of the week in the current column.
You can use WEEKDAY and FILTER function to get a list of dates in a new place.
Alternatively, use an additional column with the WEEKADY function to set a filter on that column.
Sorry, your reply does not relate to my point.
I have the below calendar formula and have been searching for days and days to insert a ceiling function to highlight every other Friday and have not been successful. "P9" is a cell that has "July 1, 2022" in it. Please help. Thanks.
=TEXT(SEQUENCE(54,7,-MOD(WEEKDAY(P9,2),7)+1)," [>"&DAY(EOMONTH(P9,0))&"];;#")
Hi!
I don't really understand what you want to do. To get the July calendar, try changing 1 to 2 in the formula. If this is not what you wanted, please describe the problem in more detail.
Hi, I would like to exclude weekend in my column, instead of i filter out weekend and weekday in new column, is there any ways to just filter in those column
Hi!
In cell A1, write the starting date. In cell A2, write the formula and copy it down along the column:
=IF(WEEKDAY(A1+1,2)>5,A1+3,A1+1)
Hope this is what you need.
I have a spreadsheet with SUNDAY-SATURDAY tabs at the bottom for each day. I would like to be able to put the date in the SUNDAY tab and it auto-populate the date for the remaining 6 tabs (Mon-Sat). Is that possible? I've tried a few different formulas and can't figure it out.
I am currently just going to each tab and changing the daily dates each week. It would be nice to just change Sunday and it populate the rest for me.
Thanks!
Hello!
I don't quite understand where you want to put the date. If the date is written in a cell, then every next day means adding 1 to the date. If you want to change tab names, you can only do it manually or use a VBA macro.
To be more clear... I am not trying to change the name of the tabs itself. I have a cell in each tab for that days date that I want to auto-populate.
Hi!
Here is the article that may be helpful to you: Adding days to a date in Excel.
Thanks! This was exactly what I needed! I was making it way more difficult than just =SUN!C1+1 for the date cell in the Monday tab, then +2 for the cell in the Tuesday tab, etc..
Is there say week 18 and Tuesday shown as 18.2 and plus 4 days show 18.6. After 18.7 next is week 19. Any formula to do this.
Hello!
Use WEEKNUM and WEEKDAY function:
=WEEKNUM(B1)&"."&WEEKDAY(B1,2)
This should solve your task.
Please help. I track shipments per week of the year (week Num). The current capacity is shipping two orders per week. If there are more than two orders per week listed, what formula do I need so the orders greater than two are moved into the following week?
Thanks for your help.
Hello!
In a separate column, determine the week number using the WEEKNUM function. Then use the COUNTIF function to count the number of times the desired week number occurs.
I hope my advice will help you solve your task.
Can anyone help with what is wrong in this formula
=COUNTIFS(B2:B5,">=EOMONTH(TODAY(),-2) +1",C2:C5,"N/A",D2:D5,"<=EOMONTH(TODAY(),-2) +28")
it's return value is just zero. please help me.
here is the data:
B2:B5 =
01/02/2022
01/01/2022
01/02/2022
01/01/2022
C2:C5 =
04/09/2022
N/A
30/03/2022
N/A
D2:D5 =
28/02/2022
31/01/2022
03/03/2022
30/01/2022
Hello!
Your formula contains errors. Read carefully how to use COUNTIFS function with dates.
=COUNTIFS(B2:B5,">="&(EOMONTH(TODAY(),-2)+1), C2:C5, "N/A", D2:D5,"<="&(EOMONTH(TODAY(),-2)+28))
The formula returns 0 because all dates in column D are greater than 28-Jan-22
How do i formulate it to say yes if it is a weekday and no if it is a weekend?
Hello!
Use the WEEKDAY function to determine the day of the week. Then use that in your IF formula.
=IF(WEEKDAY(TODAY())>5,"Yes","No")
I hope my advice will help you solve your task.
Hi! Given a column of dates in the form, month, followed by the year...such as...
Jan-2000
Feb-2000
Mar-2000
.
.
.
December-2000
How can I separate the month from the year? I would like the months in one column, followed by its year in the next column. The goal is to create fields or "month" and "year" in a pivot table. Thank you.
Sue
Hello!
You can select the month from the date using the MONTH function. Highlight the year - using YEAR function. Or use a custom date format.
This should solve your task.
Greetings from Ireland, is it possible to configure the WEEKNUM formula so that it yields a day of the Mon-Fri works well? For example, Monday would be "XX.1", Tuesday would be "XX.2", etc.?
Thanks for your help. David
Hello!
I don't really understand what you want to calculate.
However, I’ll try to guess and offer you the following formula:
=WEEKNUM(A4)&"."&WEEKDAY(A4,2)
If this is not what you wanted, please describe the problem in more detail.
Hey, I was wondering if you could possibly help me.
I am trying to figure out the amount of days late a tenants rent is. I am using this formula but it is not working, am I doing it wrong?
=DAYS((today(),datevalue(2021/06/08))
Basically, I just need to know if the tenant's rent is due on the 8th of any given month (for this we can say June 8 2021) and by today the rent still is not paid how many days late are they, including today. I mean I can do the math and I know it would be 178 days late, but is there a formula to put in the cell so it will calculate it automatically? Also, I think that if I just change the month in the following cells (ex July 8, 2021, Aug 8 2021) it would still work? Yes?
Thank you in advance, any help you can offer would be super. I think if I were to use such a formula it would be super useful when I am sending the tenant reminder letters that their rent is late, so if they needed the file they could make a spreadsheet of their own if they wanted to.
(Just because I feel it is important to add: No, I am not heartless, I am not trying to put tenants out on the streets, but looking to give them a breakdown of their rent so they can apply for help paying their back rent due to the current pandemic affecting them, if that is what they need.)
Hello!
In the DATEVALUE function, the argument must be written as text. Add quotation marks.
datevalue("2021/06/08")
You can also calculate the difference between dates using the DATEDIF function.
I hope my advice will help you solve your task.
Thank you so much, That is Perfect! it works now. I appreciate you.
Hi,
I Has One Problem In Google Sheet.
Why My Google Sheet Only Cell G29 & G30 Cannot Be Change To "ddd"?
I'm Confuse.
Hi,
I want to mentioned 0 on saturday or sunday of every month on rest date & weekdays reflects 1. how to do this in execl,
Hi,
I have data in column A as below
Mon
Tue
Wed
Thu
Fri
Tue .... and so on depending upon the working day of a person in shift.
So practically speaking the working day of the next week is Tue and not Mon.
How do i post in Column B that start of week day for that person.
Thanks and regards
Govind
Hi, I've spend many weeks on trying to find a solution to calculate number of days per week. My Sheet has twelve columns for each month of the year. Below each month I have 5 columns for W1, W2, W3, W4 and Week 5. I need to know number of days for week1, meaning from 1 Jan till first Friday. Then Week2 till second Friday (will always be 5 days) and so on for all weeks, except last week will be from last Monday of the month till the end of the month. Currently I do this manually for all 52 weeks of the year by looking at calendar.
Hi ther, plz help me on this,
I have to do fortnightly payments (on Every alternate Friday) if i received a job card on monday or Thursday, that payment date( due date) should be reflect as alternative friday date on received date in excel payment sheet.
Please help me on this.
Svetlana, Merry me!
Dear Sir,
My doubt is quite a basic one. I have the Seven Days of the week. I want to now create a dummy for those days as
Monday to Thursday = Weekday
Friday to Sunday = Weekend
How do I do that in Excel?
Hello!
Use the WORKDAY.INTL and NETWORKDAYS.INTL functions.
You can learn more about WORKDAY.INTL and NETWORKDAYS.INTL functions in this article: Calculating weekdays in Excel
I hope this will help.
Hello
I want to identify last Thursday of each month from all Thursdays by a formula from given dates of style 04FEB2021,11FEB2021, and so on. Thanking you in advance.
Hello!
To find the last Thursday of the month use this formula
=EOMONTH($A2,0)-MOD(EOMONTH($A2,0) +2,7)
A2 - cell with date.
To convert text to date, I recommend reading this article.
Hello,
I have a very complex tracking sheet for my work.
One of the functions counts the amounts of any specified day within a date range.
I would like to add one more part to this formula and am not sure how.
Current formula:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(Z2&":"&AA2)))=V2))
Is there a way so that my formula will equal 9, (instead of 10) in cell AC when it is complete? The formula would need to use a list of populated holidays from another sheet titled “Lists”. That range of holidays is - F2:F5. When it calculates, it will determine that because the Day after thanksgiving is a Friday and falls within that range, it will automatically subtract an additional day.
How can this be accomplished?
Thank you in advance!
Hello!
Unfortunately, without seeing your data it is impossible to give you advice.
I'm sorry, it is not very clear what result you want to get. Could you please describe your task in more detail and send us a small sample workbook with the source data and expected result to support@ablebits.com? Please shorten your tables to 10-20 rows/columns and include the link to your blog comment.
We'll look into your task and try to help.
I received your email and it works beautifully!!
Thank you!! LIFE SAVER!!
I have a production schedule on excel that the date column feeds off another cell. Basically todays date , plus the amount of time in the daily work schedule. Formula currently is = I3 +TODAY() So if today is 8/28 and I have 20 + jobs in lines I3,I4,........and so on. Each one adds up to .25 of a 8 hr shift. So my sheet shows 8/28 for the 1st 4 lines, on the 5th line it turns to 8/29 as it should as my 8 hr capacity is used up. My issue is I cant figure out how to take out Sat. and Sun and holidays from being populated as dates, therefore making it look like I can complete jobs sooner cause its using those 2 day we dont work on.
Hello!
If I understand your task correctly, the following formula should work for you:
=WORKDAY(TODAY(),I3,E1:E6)
For more information on how to add weekdays to a date, read here.
I need to generate a formula to where If Tuesday a cell value = 1 and if any other day of the week the cell value = 2.
I have been trying to work with the =Weekday but so far, unable to get it to work.
Thanks for any advice in working through this.
Thanks
John
sir i need formula for create a list of working days dates ignore Saturday,Sunday dates require date list based on date in a cell reference (like 7/1/2020,7/2/2020,7/3/2020.7/6/2020,7/7/2020) thank you
Hello!
I recommend reading this article on calculating working days. If there are difficulties, give an example of the source data and the expected result.
It’ll help me understand it better and find a solution for you.
I have a cell with a date that is changed each week in A1 and formula to give me the day of week starting with Sunday ending Saturday and also give the date of each day based on the date in cell A1. The following formula is used in each cell C5:I5 =DATE(YEAR($A$1),MONTH($A$1),DAY($A$1)) C5 is Sunday Then D5:I5 adjust the Day($A$1+1) it's +1 for Monday,+2 for Tuesday,+3 for Wednesday,+4 for Thursday,+5 for Friday,+6 Saturday. My problem is since June only has 30 days it skewed the DAYS of the week but the DATE is correct, so it reads Sunday 28th Monday 29th Tuesday 30th Monday 1st Thursday 2nd Wednesday 3rd Thursday 4th. If I change the formula starting on the first thru 4th to be =DATE(YEAR($A$1),MONTH($A$1+6),DAY(I5+1)) then it works until there is a change from 30 to 31 day month.
Is there a formula that will recognize and make the adjustment automatically?
Hello Cindy!
I propose the formula = $ A $ 1 in cell C5, the formula = $ A $ 1 + 1 in cell D5, the formula = $ A $ 1 + 2 in cell E5, and so on. I think this will help solve the problem.
Hi, please would you know the function or a way i can use to get the weekend (Saturday) date of a particular day in a week. Let's say i want to automatically get the weekend date of today (6/23/2020) in my cell. conditional formatting didn't work for me. Thanks in anticipation.
Hello Michael!
If I understand your task correctly, the following formula should work for you:
=A1+(8-WEEKDAY(A1,16))
In WEEKDAY function, use parameter 16
I hope this will help
Wooooooow! I wish could give a hug right now. It worked perfectly. You saved me a lot of stress. Thanks a lot, great work you're doing here!
=OrText($B$3,"DDD") ="SAT",text($B$3,"DDD")="SUN" Hi.am trying to use this formula in conditional formating, to highlight Saturdays and sundays..can you please help me... there is something am missing... can you please help me
Hello!
The formula below will do the trick for you:
=WEEKDAY(B3,2) > 5
I hope my advice will help you solve your task.
Thank you..i think there is something wrong with my excel...all the other formulas are working fine,, but only this weekend highlighting formula is not working for me.
Hello
Can you help me?
I need to add 2 days if the date falls on a Saturday and if it falls on sundays, we add 1 day
Hello!
You need to determine the day of the week using the WEEKDAY function and apply it as a condition in the IF function
=IF(WEEKDAY(A7,2)=7, A7+1, IF(WEEKDAY(A7,2)=6, A7+2,A7))
Hope this is what you need.
=OrText($B$3,"DDD") ="SAT",text($B$3,"DDD")="SUN" Hi.am trying to use this formula in conditional formating, to highlight Saturdays and sundays..can you please help me... there is something am missing... can you please help me
Hi, I am having an issue and I do not understand why this is happening.
I am using Google Spreadsheet.
My year begins on a Sunday, December 29th (cell B1) and ends on Saturday, January 4th (cell B4)
Since the formula WEEKNUM refers to the date in cell B1, and is a Sunday, I omitted the type since the week begins on a Sunday, per Excel reference sheet: -> System 1: The week containing January 1 is the first week of the year, and is numbered week 1.
But whatever I do, it always returns as week number 53 instead of 1, as it should be.
The second issue is that the second week begins on Sunday, January 5th (cell J1) and ends on Saturday, January 11th (cell P1). Since the formula still refers to the Sunday of the first day of this week (January 5th), It returns as week number 2.
That would be correct week number is the first week wasn't considered as week #1.
Because of this issue, Week 1 does not exist and causes problems with futur weeks and years.
I would be very grateful if you could help me find a solution to my problem.
Thank you very much and have a good day :)
Sorry, I meant to say in my second sentence: "I am using Excel 2013, I got a bit distracted"
Hello,
I have a question and maybe someone could help me here.
How can I make a formula to count for the whole year weeks and dates with more then 1 cell with the same date?
FX:
Week1 01/01/2020
Week1 01/01/2020
week1 02/01/2020
week1 02/01/2020
Thank you in advance and have a nice day!
Hello!
I’m sorry but your task is not entirely clear to me.
For me to be able to help you better, please describe your task in more detail. Please let me know in more detail what you were trying to find, what formula you used and what problem or error occurred. Give an example of the source data and the expected result. For example, Week1 01/01/2020 - is it one cell or several?
It’ll help me understand it better and find a solution for you. Thank you.
Hello,
I am new to excel. Could you please help me? Is it possible to set a range by using "TODAY()" with a certain cell? For example: =SUMPRODUCT(--(WEEKDAY(TODAY():B34)={3,5}))
Hello!
I’m sorry but your task is not entirely clear to me.
In the WEEKDAY function, you can record WEEKDAY(B33:B34). And in cell B33 write the formula =TODAY(). For me to be able to help you better, please describe your task in more detail. Please let me know in more detail what you were trying to find, what problem or error occurred. It’ll help me understand it better and find a solution for you. Thank you.
I have a table of lunch expenses. I have dates of May on B4:B34, the expenses on E4:E34, and a fixed budget for the month. I need to sum all lunch expenses except Tuesdays and Thursdays and figure out the left budget for lunch expense to spend till the end of the month. So What I want is to sum all Tuesdays and Thursdays from today to the end of the month so every morning whenever I open the file I would know how much is left to spend for lunch. That formula is just a part portion. Sorry, if I didn't make it clear still.
Hello!
To add all expenses for Tuesdays and Thursdays, use the formula
=SUMPRODUCT((WEEKDAY(B4:B34)=3) + (WEEKDAY(B4:B34)=5),E4:E34)
I hope this will help, otherwise please do not hesitate to contact me anytime.
Hello,
Thanks for taking time to help me out. What I want to do though is to use "today()" within sumproduct fuction. I want the computer automatically calculate left days of the month from "today" excluding Tuesdays and Thursdays, not the amount of the expenses but the actually days.
I need the mathematical number sentence like this:
Lunch Budget ÷ (Days Left - (Tuesdays & Thursdays from the left days)*)
* Since I have to check the left lunch budget each day I want to use "today()" function.
I came up with this formula and it worked:
P27(LUNCH BUDGET) | B34(LAST DAY OF THE MONTH) | B31(TODAY'S DATE)
P27 / ((NETWORKDAYS(TODAY(),B34)) - SUMPRODUCT(--(WEEKDAY(B31:B34)={3,5})))
but, I want to make it like this:
P27 / ((NETWORKDAYS(TODAY(),B34)) - SUMPRODUCT(--(WEEKDAY(today():B34)={3,5}))) or
P27 / ((NETWORKDAYS(TODAY(),B34)) - SUMPRODUCT(--(NETWORKDAYS(today(),B34)={3,5})))
but both won't work.
I hope it help you to understand better as to what I want to figure out.
Please help and thank you so much!
Hi,
I try to get a result for the following example: if today is 04/14/2020, and last month 03/14/2020 fell on the weekend, what formula does it apply to bring me the next working day in March = 03/16/2020?
Thx
Hello Cristian!
If I understand your task correctly, maybe the following formula should work for you:
=IF(WEEKDAY(EDATE(A1,-1))>5, WORKDAY(EDATE(A1,-1)-1,1), EDATE(A1,-1))
Hope you’ll find this information helpful.
In weeknum suggestions why we have to use different numbers for monday like 2,3(0-6),11 and for sunday 1,17. For ex: for sunday we can use 1 right, why 17 also there for sunday, and where will have to use 17, is there any logic for using 1 or 17, like here we have to use only 17 for sunday but not 1, please let me know this, thankyou
Hello Kiwi!
The list of possible values for the return_type argument in the WEEKDAY function is set by Microsoft. You simply choose a type from the list which suits better for your task. You can use any of the them as they just determine what day of the week to use as the first day.
Hi, I am trying something a bit different than what ever everyone else seems to be doing. I hope you can help me as I've been trying different ways for a very long time now and am getting nowhere fast.
I am building a weekly schedule and can allocate weekdays easily. I am trying to enter holidays into this formula but it does not work. I don't care about how many days it takes. I am only concerned with what my end date will be (without weekends or holidays).
This is what I've been entering so far..Example (=weekday,1). "weekday" being in the box next to it. then I simply follow through with that formula across the row and it self tabulates the weekdays only. When I try to enter a holiday with it...example (=weekday,1, B6:B12) "these would be dates in a different box", it does nothing. hope this makes sense. Please help if you can.
Hello Rob!
If I understand your task correctly, the following formula should work for you:
=IF(AND(WEEKDAY(A1,2)<6,ISNA(VLOOKUP(A1,$G$1:$G$7,1,FALSE))),"workday","holiday")
where $G$1:$G$7 - list of holidays.
10-1-2019 1:30AM, - 12-1-2020 3:10AM total year,munth,dd, Hh,mm Excel convert plg sent
i have this date 08-01-10 11:15
and i want to transform it to day of the week...
any suggestions?
Day 1 in Excel is January 1, 1900.
Weekday of this date gives a Sunday.
However, when you Google for a calendar image of January 1900 you get a Monday.
Can anyone explain this anomaly?
Thanks,
Fred
I have a range of random dates in column b3:b30 and wish to find the oldest date and convert to the corresponding Monday
How do I nest and use the MIN and Weekday function in excel?
I have problem when creating =WEEKDAY($A2,2)>5 for year 2020 Feb 28 cross over to Mar 01. My "Sat" did not appear. It turns out to be a "Sun". I've checked the cell, the date is 01/03/2020 but ddd turn out to be a "Sun". How can I solve this?
I am using conditional formatting to highlight weekends. If the first falls on a weekend it does not highlight. I am using =OR(WEEKDAY($A1)=7,WEEKDAY($A1)=1). What is wrong?
Hello Bill,
Since 30 and 31 of December is the 53rd week of 2019 and 1st to 5th January is the first week of 2020, the formula for this particular week needs some modification. Please try the one below:
=IF(OR(WEEKNUM($A1, 1) = 53,WEEKNUM($A1, 1) = 1), TRUE)
Hope it'll work for you.
Thanks for the tip, but it didn't quite work. I am using a new spreadsheet for the year. However, I did get it to work by starting it in the correct cell (not $A1 but $A2). I like your site, I have learned a lot from it.
Thank you for replying, Bill. Glad to hear you found a solution!
Sir..i need to formula.one cell i enter month and i get result in column sequences ..wed..thu..sun..wed..thu..sun..wed..thu with date for this month
Can I actually do this? :)
I have this format in the cells for date and time:
04:35 PM EDT Oct 29 2019
How can I create a formula for finding how many minutes elapsed between cells in column A (arrival time) and column B (departure time)?
I want to calculate how long my visitors spent in my office.
Hi Team,
I am working in a BPO industry. I need to track the production as well as the other details in day wise. For example The date is 1st November, in need to track the Target, Achieved, Production. So I have merged the 1st November header has been merged into three above cells. I do not have any issues on this. Please help me out to convert into weekly basis with the same header.
I'm looking to calculate the date of the year based on a day.
I'm doing some analysis using 31 years of day and have a mean value, 45 (i.e. day 45 of 365). I want to convert 45 to represent a date, so I don't have a generic year to plug in.
What would be the excel formula to do this?
How can i calculate the first (1st) day of each calendar month or the immediately preceding Business Day if the first (1st) day of such calendar month is not a Business Day?
Is there a way to calculate the day of the week with the numbering 1-14 instead of 1-7?