sitewolf
Active Member
- Joined
- May 4, 2012
- Messages
- 304
It could be all my neurons simply aren't firing yet this morning, because I think this should be relatively simple but it's just not coming to me.
Each month I have a list of transactions, but because the (external so I can't change it) cutoff date isn't the first of the month, that list will always have some transactions from both the prior month and the current month. I want to keep the correct dates in my transaction log, but to upload into my accounting software I want dates to be all current month.
Example dates from my log:
9/27/22
9/29/22
10/4/22
10/7/22
What I want is an if statement where if a date is = or > than the 1st of the current month, it uses the correct date, but if it's < the 1st of the current month, it spits out the 1st of the current month.
In the above example, then, the formula would spit out 10/1/22 for the first 2. There's a journal entry date I'd be typing in to use as the current month, so I don't have to futz with that part of determining current.
Each month I have a list of transactions, but because the (external so I can't change it) cutoff date isn't the first of the month, that list will always have some transactions from both the prior month and the current month. I want to keep the correct dates in my transaction log, but to upload into my accounting software I want dates to be all current month.
Example dates from my log:
9/27/22
9/29/22
10/4/22
10/7/22
What I want is an if statement where if a date is = or > than the 1st of the current month, it uses the correct date, but if it's < the 1st of the current month, it spits out the 1st of the current month.
In the above example, then, the formula would spit out 10/1/22 for the first 2. There's a journal entry date I'd be typing in to use as the current month, so I don't have to futz with that part of determining current.