If one cell in line turn empty then entire line turns empty

Originally Posted by LaffyAffy13

Hope that helps!

Thank you!

I know my main question is already solved but I thought in not creating a new thread for one more question about same worksheet.

You see next to columns that should be filled with dates there are a small cell for numbers which goes like this:

If date of billing is like 9/21/13 then it should be filled with number 9 which means month 9 as mentioned on table of caption. At this moment it will be filled manually since I could not make a formula for IF in these cells because of date. Would you know by chance a easy way to automatically fill the number of month right after imputting the date on month cell?

Kind regards!