I can't figure out how to create a formula to give me a number using the current date based on the month and stop calculating. So lets say the current date is May 04/06 and I want the cell to show the number 4, then 5 when its May 05/06 and so on. Well I'm using a formula that does that, which is =Day(Today()). However I need this formula to stop calculating at the end of the month. So if its May 31/06, then the cell should reflect 31. But once the date is June 01/06 then my number is back to 1. I need it to only calculate based on the month I assign to it. I've been playing with this for ever and can't figure it out.
Bookmarks