#datesinexcel

Hi Everyone, I have this formula (See Below) to tell me which days of the week is most popular. But now I am trying to figure out how can I go into my date column "Income_Dates" and find out if the appointments are in the 1st, 2nd, 3rd, 4th, or 5th week of the month. Trying to figure out...

Hi Everyone, I"ve been trying to figure out how to do this and been stuck for over a week. I created this custom report table, which works great. But the problem, I'm having is if I enter a "Start Date" which has a different year then my "End Year". It doesn't include the data from the...

Hi Everyone, I"ve been trying to figure out how to do this and been stuck for over a week. I created this custom report table, which works great. But the problem, I'm having is if I enter a "Start Date" which has a different year then my "End Year". It doesn't include the data from the...

Is it possible to send an email reminder based on a specific date & time via Excel? If it is possible, does Excel have to be open to send or can we set the dates and basically forget about the spreadsheet until it needs to be updated? Below is a checklist where tasks are to be completed before...

On the heading of my weekly report I wanted the week start date "Saturday" and the end date "Friday" should show automatically when I open the sheet and should change with the date of the month automatically. I did not want to change it manually every week. I achieved the same by the below...