We create our journal entries on excel files. and to ensure that we are not picking up the previous' month or have an invalid date in the date field we wanted to create a visual for the user to see if the date showing in the field is not from a previous' monthly close or a future month.
So, our JV are created from about the 20th of the month to the 10th of the next month. So, for example if we were creating a JV on 4/22/10 to 5/10/10 we woudl be creating a JV for the month of April. So the user should input a date on the JV file from 4/22/10 - 4/30/10. Anything outside of this would highlight the field for error. This needs to be a carrying forward field that can be used for any month.
So, I have created a formula I think will capture the furture date, but I can't figure out what i'm not doing. Here is the formula: =IF((DAY(TODAY())/30)>0.67,IF((MONTH(TODAY())+30)=(MONTH($B$4)),21,13))
I am always getting the 13 as the value result. Any help would be appreciated.
So, our JV are created from about the 20th of the month to the 10th of the next month. So, for example if we were creating a JV on 4/22/10 to 5/10/10 we woudl be creating a JV for the month of April. So the user should input a date on the JV file from 4/22/10 - 4/30/10. Anything outside of this would highlight the field for error. This needs to be a carrying forward field that can be used for any month.
So, I have created a formula I think will capture the furture date, but I can't figure out what i'm not doing. Here is the formula: =IF((DAY(TODAY())/30)>0.67,IF((MONTH(TODAY())+30)=(MONTH($B$4)),21,13))
I am always getting the 13 as the value result. Any help would be appreciated.