Attached is a work sheet similar to one I am working on. Its for my personal bills. I want the 1st and 15th of every month to automatically generate and the 1st of every months bills to be applied, the same with the 15th. I hope the excel sheet explains it...
Thanks for your help.
Excel help.xlsxExcel help.xlsx
Hi and welcome to the forum.
What determines which month is to be used for evaluating the 1st or the 15th. i.e. Why is B2 testing 1/15 April and B4 1/15 May.
Is it the column A date that determines the month to be used or column C. The fact that B4 is May suggests its C4 but you need to clarify.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Richard,
Thanks for your reply. I think you're right, Column C would determine the month.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks