Mr Excel & excelisfun Trick 33: First Monday For Reporting Period

See Mr Excel and excelisfun show three formulas for finding first Monday of reporting period:
If 1st day of month is Monday, then that day, otherwise the last Monday of the previous month. See the functions EOMONTH, WEEKDAY, DATE, MONTH, IF and DAY

Category:

Science & Technology

Tags:

• Excel
• First
• Monday
• For
• Reporting
• Period
• EOMONTH
• WEEKDAY
• DATE
• MONTH
• IF
• DAY
• functions
• excelisfun
• Bill
• Mr
• Jelen
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[yosoyisrael]

can anyone help? I need a formula that can tell me when a date is over due.or is about to be over due. ... for instance... employee badge expires on 05/01/09... and the present date for that

[ExcelIsFun]

If date is in cell A1, then this formula will tell you if the current date is over the date in cell A1:

=IF(A1>TODAY(),"Past Due","Not Over Due")

[ExcelIsFun]

You can also watch this video:

Excel Magic Trick #12: Date Math!

[indiaujla]

i noticed that there were a couple of times when Bill automatically resized the column, without having to double click on the column name at the top of the window. is there a trick to do this?

[ExcelIsFun]

Best fit columns:

Alt H + O + I

[deekaaboy]

Hello, well I got a small question, Where's your email adress again?

I got a question which i'd like to mail, Thanks in advance, Kind regards

[ExcelIsFun]

YouTube does not allow us to post e-mail or web addresses in comment section.

Search for "excelisfun", go to the excleisfun YouYube channel, look on the left for the "Send Message" link.

[ExcelIsFun]

search for excelisfun here at YouTube. Then go to the excelisfun channel and use the e-mail link there.