In the attached, I need a formula for Cell A2 in Sheet1 that returns a date (last day of the month) in MM/DD/YYY format based on values being held in Sheet 2, Cells B7 and B11. Naturally, in my use, the month you see won't always be April.
In the attached, I need a formula for Cell A2 in Sheet1 that returns a date (last day of the month) in MM/DD/YYY format based on values being held in Sheet 2, Cells B7 and B11. Naturally, in my use, the month you see won't always be April.
Try:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Excellent, thanks.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks