troubleshooting Question

Excel Date

Avatar of W.E.B
W.E.B asked on
Microsoft Excel
3 Comments1 Solution307 ViewsLast Modified:
Can you please help,

I need to have a formula in Cell A1

If Today's date > = 1st and < = 14th then
CELL A1 = 16th of Previous Month -- CELL B1 = Last day of Previous month.
If Today's date = 15th then
CELL A1 =  1st of Current Month -- CELL B1 = 15th of Current Month
If Today's date > = 16th and < = End of Month then
CELL A1 =  16th of Current month. -- CELL B1 = Last day of Current month.

not sure if this can be done in one formula,
if not, I'm OK with 2 formulas (CELL A1, B1)

Any help is appreciated,

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros