I have a reporting spreadsheet that gets updated monthly and I need to have a cell display when the last report was taken in relation to the current date. i.e. if today is 6/20/2011 I need the date of report cell to say 5/31/2011 because that is the date of the most recent update.
Last edited by erikwvb; 06-20-2011 at 01:21 PM. Reason: solved
Try this regular formula:
=TODAY()-DAY(TODAY())
or
=EOMONTH(TODAY(),-1)
Format the formula's cell as a date.
Is that something you can work with?
Thanks,
Works fine now!
Last edited by erikwvb; 06-20-2011 at 01:21 PM.
Yes, exactly what are you typing into your formula?
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks