Get 1st day of current and previous month - vba

Hi,

I am wondering how to get the 1st day of the current month based on today's date and 1st day of the previous month based on todays date.
I have tried =TODAY()-DAY(TODAY())+1 which gave me an error.

Thank you

I've worked this out but now have a different problem. I want to take the date of one cell, cell B5 and minus 1 then print that date in cell B6. Ive got this code so far that does take the value from B5 and subtracts 1 but it pasts onto B5 and not B6.

Please Login or Register  to view this content.

Thanks in advance!!!

Thank you GC Excel, I didn't see that comment. Could you please help with my recent problem too?

Thanks a million!!!

GC Excel, you are a legend!!! Thanks so much!

Can someone help with this:

I want to have the text Due and then the month. The month prints but not the word Due.

Please Login or Register  to view this content.

Thanks

Can someone help with this:

I want to have the text Due and then the month. The month prints but not the word Due.

Please Login or Register  to view this content.

Thanks

Amazing! Thanks GC Excel!

Hi Everyone,

I am trying to use insert slicer to connect 4 pivot graphs together. But the 'Insert Slicer' button is greyed out. It is in .xlsx format and the insert slicer works on my pivot tables but I need it for my graphs only which it doesnt work for.

What can I do? I read online it could be privacy reasons, how can fix this?

Any ideas?

Thanks