todays

I am not sure if this is possible or not but I am trying to write an if condition for a sum on a spreadsheet that if it doesn't meet the criteria that it doesn't calculate and leaves the previous value This is my if statement =IF(A1="final",SUM('Post 9-30am payments'!B1+'Post 9-30am...

Can someone help please? I have a range of cells (B2-E10) which have a number of important dates I require to track. Can I code that when I open the workbook if todays date is less than or equal to the 5 dates leading up to any of the important dates a msgbox will appear? Any help appreciated.

hi all , I have a column AI in which dates are given in (MM/DD/YYYY) I am looking for a macro which selects all the dates in Column AI apart from today's date . If anyone can help !!!

Hello, I have a spreadsheet with row wise dates in column A. I need a vba code to automatically protect cells with password from column A to J (row wise) when Today's date is passed. Could anyone help me with a code? The code should not start with Sub "Private Sub Worksheet_Change" as I already...

Hey all, Love this place of wisdom! May I please have a macro button on the same sheet that says: If start date in cells D10:D100 has passed today's date and end date in cells E10:E100 has also passed today's date, delete values in B10:E100 and G10:I100, then sort column D10:D100 by oldest to...

Hi Everyone, I have a sheet with this years calendar in it (so you can imagine it 365 columns wide I row1 I have the dates Start In Column G with 01/01/2017 and go up one day at a time across the page to give me my calendar in A2 in Have todays date hat Id like is a macro that when I select...

Hi Forum, I am trying to create a formula which will calculate the working days date. If column A is having today's date and yesterday's date then result should be same and If column A is having prior to yesterday's date it should show today's date. Below formula is working correct with weekdays...