Ifs and End of months

[ylwcat11]

I need help writing a formula... Here is the situation....

If the item was purchased through "X" then the fixing date needs to be 3 days before the end of the month.

If the item was purchased through "Y" then the fixing date needs to be the last day of the month..

Now for both ifs, I need to compare the fixing date to the end date and make sure the above is true...

Can anyone help?

Thanks!

 

[WaxonWaxov]

"Now for both ifs, I need to compare the fixing date to the end date and make sure the above is true..."

huh?

If cell D10 contains the date in question, you can get the last day of the month like so..

=DATE(YEAR(D10),MONTH(D10)+1,DAY(D10)-DAY(D10))

 

[barry houdini]

Hello ylwcat11, welcome to MrExcel

If you have the "fixing date" in A1 end of month in B1 and "X" or "Y" in C1

=B1-A1=IF(C1="X",3,0)

Then that will give TRUE or FALSE depending on whether the dates are right given the value in C1. Is that what you need?