MikeyMike1828
New Member
- Joined
- Dec 17, 2004
- Messages
- 9
I need to keep track of monthly sales but the months ends in the middle of the month example Let's say a sales month ends 01/21/2005. How can I have a cell automatically change to 02/01/2005? I tried using the function date and the today function. Once the month changes in the today function the date function would change. Example if today's date was 01/31/2005 the cell that has the date function would be 1. Then when it turns to February the the cell with the function date would be 2. There has to be a easier way to do this. If that doesn't make any sense I will try to explain a better.
Thanks
Thanks